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
C352. Is there any way of doing this? :confused
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
G
Guest
one way to do it
=sumproduct(--(mod(row(C7:C352)=2),c7:c352)
=sumproduct(--(mod(row(C7:C352)=2),c7:c352)
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.
=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)
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 :
how to do that :