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

[@JohnnySix]

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

[@smart-office12]

Thank you 🙏

[@mohamedshuaib2088]

Thank you for the clarity of information of new formulae .

[@hava575]

Thank you very much, very clever and net solutionn

[@smart-office12]

Welcome 🙏

[@AanchalSanwaria-r3x]

Thank you for making it easy. Saved time.

[@smart-office12]

Welcome 🙏🙏

[@muzammilsirguroh5260]

great help indeed!

[@villagetamilan4319]

for some reason, if i reverse the forumla without =0 and for the other one with 0 works for me...

[@divinkottummal5128]

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

[@smart-office12]

Welcome🙏

[@siddharthpahwa2812]

Very helpful video sir Thanks Great work

[@smart-office12]

Welcome 🙏

[@sksboss]

Very helpful, thank you

[@smart-office12]

Thank you too🙏

[@omprakashthakur4515]

So helpful tips and tricks Thank you so much sir

[@smart-office12]

Thank you

[@Jacobamalraj]

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

[@smart-office12]

Welcome

[@lallanvip]

Can I total it by the heading of colomn

[@MrKumarTheBoss]

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

[@abuhamdanmohdshafi2506]

Very usefull..thank you very much

[@Doptif]

Also can do it using sumifs

[@stenionet]

Thank you very much. It's working perfectly.

[@smart-office12]

Welcome

[@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'.

[@sheilazapata7049]

Hi! How can i sum alternate multiple column?

[@omprakashthakur4515]

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

[@LifeByDenise]

Thanks! This is so helpful.

[@smart-office12]

Thank you

[@sreekanthbiyyamkar3561]

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

[@smart-office12]

It should work, please share the file to [e-mail] if it still does not work.

[@FrancisDSouza-l4s]

Sir i made 3 columns amount, paid & diff the formula is not working as mentioned in the video

[@smart-office12]

can you plz send me email mentioning the issue along with the workbook file? I will check and revert back. Email: [e-mail]

[@pinkyshah4413]

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

[@smart-office12]

This video might help you, if not please let me know kzbin.info/www/bejne/sJnbk42ndrFmZpIsi=M7iscL-q1Sj6PVlf

[@vinodjindal4354]

Wonderful video

[@hokuspokus3599]

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

[@rajnishkumarsingh1922]

Sir how to calculate if each month have four column and we want to calculate first row of each month

[@rajnishkumarsingh1922]

Please help i have urgent to know how to calculate

[@smart-office12]

Keep 4 in the divisor of Mod function, rest of all same

[@puregreen3109]

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

[@smart-office12]

It should work, may be some error happened

[@rajarajeshwaran92]

Very informative, thanks

[@smart-office12]

Wc🙏

[@sipanmajumder7668]

very good

[@thanigairaj5322]

VERY USEFUL THANKS

[@muhammadsaadkhan6863]

Very informative ❤️

[@chinmaynikumbhe11]

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 ..

[@smart-office12]

Use this formula, =Sumproduct((mod(column(A3:S3),9)=0)*A3:S3), where A3:S3 is range of data for example and 9 is the nth column to be added

[@melvherviggoballares5528]

Hi Sir. Is the divisor always 2?

[@smart-office12]

Yes, its always 2

[@smart-office12]

Yes, its always 2

[@AmitRana-wy4si]

Nice sir mja agya

[@vinayakpotadar4093]

Super sir

[@smart-office12]

Thank you

[@2bhaiporterwale]

Even row formula plz explain

[@manojmishra6573]

How to alternate row caculated with formula

[@smart-office12]

Hi, could you more explain the requirement?

[@AmitRana-wy4si]

Sir, can you pls explain how this formula works.

[@emeamilak0621]

It says o when i click enter ?? Please help

[@smart-office12]

Please share me the workbook in [e-mail] I will check and revert

[@jitumonihearts6215]

Alternate cells ka sum kaise nikale pls help

[@vishalcoool91]

Please Use sumif formula

[@harsinchh4342]

How sum if A B C 20 30 40 10 50 90 40 60 30 70 30 60 In the above eg. I want a sum of column C from the Min or Max value of column A or B. As A2 has the first occurrence of min/max value so from there I want the sum of C column (90+30+60) C2 - C4. Please help with this question.

[@smart-office12]

Pls clearify more, min value from which column and max value from which column?

[@harsinchh4342]

@@smart-office12 Hello Sir, A B C 1.20 40 30 2.(10) 50 [60 3. 20 30 20 4. 50 10 10 5. 60 10 80 6. 30 (90) 50] 7. 20 20 70 In above eg. A2 has minimum value & B6 has maximum value, so from this range 2-6 I want sum of column C2-C6 (60+20+10+80+50). so from the 1st column minimum value cell to 2nd column maximum value cell, I want sum of in-between cells of column C. I have 1000s sets each set of 7 of 3rows with 3 columns to execute in this manner. I m providing one more eg. so that u have better understanding. A B C 1. 50 30 30 2. 60 20 40 3. (30) 10 [50 4. 90 80 60 5. 70 (90) 30] 6. 50 70 20 7. 40 40 10 from min value of column A3(30) to max value B5(90), sum all cells of column C, C3 to C5 that is [50+60+30]. Please help with this question. Thank You.

[@kamalnayan6407]

one column 1+1+1+1 inka sum next coloumn mein kaise karein

[@jyotishekhawat3937]

Ni hora is formula se sab same kia tb b

[@omprakashthakur4515]

Please sir file dinu practice KO lagi

[@smart-office12]

Plz write a mail to [e-mail]

[@chandusheth]

=SUMPRODUCT(B5:M5*($B$4:$M$4=$B$4)) &=SUMPRODUCT(B5:M5*($B$4:$M$4=$C$4)) will solve the problem.