View Single Post
  #5   Report Post  
Nick Hodge
 
Posts: n/a
Default

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