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
 
Ad

Advertisements

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

Advertisements

D

DeLyn

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

Advertisements

You must log in or register to reply here.

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

Summing every nth cell 2
Copy every nth row 0
Deleting every nth through every nth row in a column 1
Sum of every nth cell in a column 3
Paste formula every nth row 1
delete every nth row in selected range 1
Summing every 12 rows 2
how can i select every nth row? 4

Top