Thread: SUM(OFFSET)?
View Single Post
  #10   Report Post  
Jason Morin
 
Posts: n/a
Default

Just 2 other ways:

=C4+SUMPRODUCT(SUM(OFFSET(C4,ROW(1:1000)*51,)))
=C4+SUMPRODUCT(SUM(INDIRECT("C"&ROW(1:100)*51+4)))

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to sum C4 and each cell every 51st row down.

C4+C55+C106+C157+....
etc.

Any ideas?
TIA Mike F


.