Sum Every Nth Row in Excel

You may need to sum the value in every nth row in a list. This formula sums the value in every fifth row. The SUMPRODUCT function has been used along with ROW and MOD for the criteria.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[nathanjones]

This was a massive help for some of my high school students. Your explanation was crisp and to the point. Massive thanks.

[AmericanPsyko]

This worked wonders!!! Excellent explanations of each function, great job my man!

[rashidrahmad]

thanks man, you're truly a live saver.

[Bjornsin]

Worked liked a charm, thank you kindly

[harshac]

Finally I found this video. I wanted to add every nth row.

[princessmilcahsantonil]

This is very helpful! I was wondering how can we calculate the rows in between? Example would be every 4th value of the 5th row. I tried adding -1 after the array2 but does not work, only add the value of every 4th row not every 4th value of 5th row COR Percentage'!$N$5:$BC$5)-13, 6)=0)*('Daily COR Percentage'!$N$5:$BC$5)))

[fatihkaymaz]

hi sir the formula is working only if numbers on the row, on my case formula calculate every 6th row but if i add some text on row 3 or 4 it is giving value error ? is there any way to fix this ?

[lucyagnew-bg]

How do I then drag this along? So that new rows follow same function?

[vitaminlaugh]

excellent. what about the column, I mean how to do the same function if its all column wise?

[hiteshkothari]

Can you help me calculate the total sum from the sum-product formula?

S.NO EXPENSES HEAD Bank 1 Bank 2 Bank 3 Bank 4 Bank 1 Bank 2 Bank 3 Bank 4 Bank 1 Bank 2 Bank 3 Bank 4

I need total of BANK 1 by sumproduct formula

[Sharon-siec]

This is exactly what I needed to do, but I got the wrong answer. My total starts on the 10th row then I have to add every 13th row thereafter. It is 13 because there are 12 rows in between, one for each month of the year. The formula is inserted on the 9th row right above the first total on row 10. What did I do wrong?

[houarian]

want to to know ho to select the Nth row ie D5:P5 where N is a random number in column A

[zatak]

thanks for your help, and i needed one more solution, whenever the nth cell has a number, i am able to use the formula you have prescribed, but when the nth cell is a result of a calculation, it shows value error, can you please shed some light on this topic. thanks

[brazilfootball]

How would you tell excel to give you the summed numbers for each city (sum B3:B6, then B8:B11, etc.)

[jashankmadbhvi]

Nice :)

However, what if there are irregularities in the column. Foe example i need sum of every totlas that are not exactly in every fifth row??

[mariuszkrukar]

What about empty cells, that can be located between? This formula doesn't work for them.

[Maflavia]

Hi, sorry, you lost me at 7:55. How are we calculating what number to minus?

[EnrollmentCampaignCellDisttAtt]

this won't work for me. I want to add every 6th row. Please elaborate

[lolikuh]

Why is this program so shitty, this is not working btw.