Replace H2 with 2.
Aladin Akyurek wrote:
Let A2:A400 be the range of interest...
=SUMPRODUCT(--(MOD(ROW(A2:A400)-CELL("Row",A2)+0,H2)=0),A2:A400)
Teri wrote:
I can't seem to find how to do this. Want to add every other row in a
worksheet. Any ideas? Thanks!
|