View Single Post
  #6   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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!