Calculate SUM of Alternative Column or Row Data in Excel (Calculate Sum of Every Next Row in Excel)

In this video you will learn how to calculate sum of alternative rows or columns data in excel. For example if you want to add values of every next cell like A1,A3,A5,A7 etc from a large data, you can learn the formula trick from this video.

Download the practice workbook file from below link
Workbook Number. 3
#advanceexcel #excelformula #excelfunctions

[JohnnySix]

Very nice trick with Sum-product to sum the alternate rows. A lot more elegant that I thought it would be!

[divinkottummal]

This formula works in libra calc too. very useful video. thank u so much.

[mohamedshuaib]

Thank you for the clarity of information of new formulae
.

[stenionet]

Thank you very much.
It's working perfectly.

[fcbquxs]

Thank you for making it easy. Saved time.

[MrKumarTheBoss]

What if, numbers are in insequence row... Can we use 8nd3x match with sum product.

[omprakashthakur]

So helpful tips and tricks
Thank you so much sir

[Jacobamalraj]

Thank you very much. It is of great help to me.

[siddharthpahwa]

Very helpful video sir
Thanks
Great work

[sheilazapata]

Hi! How can i sum alternate multiple column?

[omprakashthakur]

Please to help me
To extract running subtraction result based on criteria but some row is empty on data

[lallanvip]

Can I total it by the heading of colomn

[hava]

Thank you very much, very clever and net solutionn

[AmitRana-wysi]

Sir, can you pls explain how this formula works.

[grehdeep]

This is just a direct solution to the problem. Would appreciate if it was followed up with a decent explanation of which function is doing what.
I can get my job done using the given formula but I still stand clueless about how the function nest is actually working.
Essentially a 'memorize' and not a 'learn how to'.

[sreekanthbiyyamkar]

Brother nice info. i have tried 1st formula workout but 2nd one for odd numbers formula not working

[hokuspokus]

Please help me when I use this it says that there’s too many arguments

[chinmaynikumbhe]

How can i get sum of each 9 number of column
For exmlp. I84 + next 8 column gqp 9th number clumn is v84 like this all till last of column each 9th number value + ... Which type of formula i can use sir.. Please guide ..

[puregreen]

Hello, didn't work in second column, result is same with total amount of the first column, but thanks for this video 🙂.

[pinkyshah]

Hello sir.. in given solution for alternate summation, how to get sum of rep B, D, F, H