Try something like this:

This function sums D3 and every eighth cell below it.
=SUMPRODUCT((MOD(ROW(D3:D1000)-3,8)=0)*D3:D1000)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Naveen" wrote:

Excel has sum limitation on "SUM".

please try with subtotal, available in "Data" menu.


*** Please do rate ***







"acking62" wrote:

I'm trying to total
=SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235)
I need to extend this further but can't add any more do to error. How can I
add more cells to calculate?