ExcelBanter - How do I add values only in odd numbered rows in Excel?

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

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

- - How do I add values only in odd numbered rows in Excel? (https://www.excelbanter.com/excel-worksheet-functions/143019-how-do-i-add-values-only-odd-numbered-rows-excel.html)

baylor basketball

How do I add values only in odd numbered rows in Excel?

I need to sum all the values in alternating rows...i.e. all odd or even rows,
or all odd or even columns. How do I type in this formula?

How do I add values only in odd numbered rows in Excel?

one way
=sumproduct(--(mod(row(A1:A100),2)=1,a1:a100)
for odd rows
....=0... for even rows

"baylor basketball" wrote:

I need to sum all the values in alternating rows...i.e. all odd or even rows,
or all odd or even columns. How do I type in this formula?

excelent

How do I add values only in odd numbered rows in Excel?

=SUMPRODUCT((A1:A10)*(MOD(ROW(A1:A10),2)=0))
=SUMPRODUCT((A1:A10)*(MOD(ROW(A1:A10),2)<0))
=SUMPRODUCT((A1:E1)*(MOD(COLUMN(A1:E1),2)=0))
=SUMPRODUCT((A1:E1)*(MOD(COLUMN(A1:E1),2)<0))

"baylor basketball" skrev:

I need to sum all the values in alternating rows...i.e. all odd or even rows,
or all odd or even columns. How do I type in this formula?

All times are GMT +1. The time now is 10:37 AM.