=SUM(IF(MOD(A1:A100,2)=0,A1:A100))
for even numbers, and
=SUM(IF(MOD(A1:A100,2)=1,A1:A100))
for odd numbers.
These are array formulae, so commit with Ctrl-Shift-Enter.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Steve E" <Steve
wrote in message
...
I need help with the formula to sum up only the odd or even numbers in a
column. I appreciate any help that you can provide.
Thanks,
Steve