adding odd numbers

[Guest]

How can I add only the odd numbers in a column of numbers?

 

[Max]

One way, assuming the col of numbers is within A1:A100

Try in say, B1:
=SUMPRODUCT(--(MOD(A1:A100,2)=1),A1:A100)

and for summing the even numbers,
just switch the "MOD(...)=1", to "MOD(...)=0", i.e.:
=SUMPRODUCT(--(MOD(A1:A100,2)=0),A1:A100)

 

[Guest]

Hi,

If your data are in the range A2:A101, in some other cell (e.g., B2) enter
the following formula: it will add all the odd numbers in the column.

=SUMPRODUCT((A2:A101)*(MOD(A2:A101,2)=1))

To add only even numbers, change the '1' at the end of the formula to '0')

Regards,
B. R. Ramachandran