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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
one way
=sumproduct(--(mod(row(A1:A100),2)=1,a1:a100)
for odd rows
....=0... for even rows
 
=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:
 
Back
Top