NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS

D

Duke Carey

For even rows:
=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20)

For odd rows:
=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20)
 
Top