Thread: SUM(OFFSET)?
View Single Post
  #8   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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