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?


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