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

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?
 
G

Guest

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

Guest

=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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I delete alternating rows in excel 4
SUM odd/even Rows? 5
Why Excel Does not increment by 2 or 3, odd/even numbers? 6
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
OLD PROBLEM without SOLUTION , part || 1
Moving data in Excel 2003 via VBA 1
Cell Shading 2
sum alternate rows 4

Top