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


"mike1448" wrote:

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