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
.
|