ExcelBanter - NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS (https://www.excelbanter.com/excel-worksheet-functions/70984-need-formula-adds-even-odd-row-numbers.html)

J Shamp

NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS

I am looking for a formula that will sum even or odd row numbers

Duke Carey

NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS

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

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

"J Shamp" wrote:

I am looking for a formula that will sum even or odd row numbers

All times are GMT +1. The time now is 01:50 PM.