Thread
:
Summing every Nth row
View Single Post
#
5
Nick Hodge
Posts: n/a
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?
--
DeLyn
------------------------------------------------------------------------
DeLyn's Profile:
http://www.excelforum.com/member.php...o&userid=24307
View this thread:
http://www.excelforum.com/showthread...hreadid=379149
Reply With Quote