Summing every Nth row

[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

 

[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

 

[Guest]

one way to do it
=sumproduct(--(mod(row(C7:C352)=2),c7:c352)

 

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

 

[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)

 

[DeLyn]

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