Of course if you have text values in there you can use any of the other 3
formulas you were given


Regards,

Peo Sjoblom

"Peo Sjoblom" wrote:

If it does you must have text in some of the cells in question

Regards,

Peo Sjoblom

"Mike Fogleman" wrote:

That results in #VALUE!
"Bob Umlas" wrote in message
...
=SUMPRODUCT((OFFSET(C4,0,0,10000,1)*(MOD(ROW(4:100 03),51)=4)))

"Mike Fogleman" wrote in message
news:XgDAd.39842$k25.6833@attbi_s53...
I want to sum C4 and each cell every 51st row down.
C4+C55+C106+C157+....
etc.

Any ideas?
TIA Mike F