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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"mike1448" wrote in message
...
How can I add only the odd numbers in a column of numbers