Summing every Nth row
 

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


--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile: http://www.excelforum.com/member.php...o&userid=24307
View this thread: http://www.excelforum.com/showthread...hreadid=379149

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


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379149

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

"DeLyn" wrote:


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


--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile: http://www.excelforum.com/member.php...o&userid=24307
View this thread: http://www.excelforum.com/showthread...hreadid=379149

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.

DeLyn wrote:

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

--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile: http://www.excelforum.com/member.php...o&userid=24307
View this thread: http://www.excelforum.com/showthread...hreadid=379149

--

Dave Peterson

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
HIS


"DeLyn" wrote in
message ...

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


--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile:
http://www.excelforum.com/member.php...o&userid=24307
View this thread: http://www.excelforum.com/showthread...hreadid=379149

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


--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile: http://www.excelforum.com/member.php...o&userid=24307
View this thread: http://www.excelforum.com/showthread...hreadid=379149