Summing every Nth row

D

DeLyn

I need a grand total of every 5th line beginning with C7 and ending wit
C352. Is there any way of doing this? :confused
 
O

olasa

This is one option:

From cell C8 to C352
....
In cell C19: =IF(MOD(ROW(),5)=0,SUBTOTAL(9,$C$7:C19),"")
In cell C20: =IF(MOD(ROW(),5)=0,SUBTOTAL(9,$C$7:C20),"")
...

HTH
Ola Sandström
 
D

Dave Peterson

One way:

=SUMPRODUCT(--(MOD(ROW(C7:C352),5)=2),C7:C352)

=sumproduct() likes to work with numbers.

The -- converts Trues and falses to +1's and 0's.
 
N

Nick Hodge

DeLyn

Enter the sum in C7. Select the cells C7:C11 and then click on the fill
handle (The little square bottom right of C11) and drag to C352. Every 5th
row will have a sum

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
D

DeLyn

Thank you guys so much! I couldn't find anyone at the office that kne
how to do that :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of every nth cell in a column 3
add or subtract every 5th column 2
The next Grand Theft Auto title has been officially announced 0
Copy Every 5th Row 6
Summing every nth cell 2
How can I choose every nth name in a spreadsheet? 3
Grand total sum of formula 6
Excel 2003 Pivot Table - Grand Total 4

Top