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

1]

=SUMPRODUCT(--(MOD(ROW($F$5:$F$958)-CELL("Row",$F$5)+0,2)=0),$F$5:$F$958)

2]

=SUMPRODUCT(--(MOD(ROW($F$5:$F$958)-CELL("Row",$F$5)+1,2)=0),$F$5:$F$958)

csfrolich wrote:
I am attempting to add every other cell in a 958 row set of numbers.

For instance: =SUM (F5+F7+F9+F11+F13......F957) and then I want to add all
the even number rows, =SUM (F6+F8+F10+F12+F14......F958).

Any suggestions other than typing this formula out.

Thanks