One way,

even

=SUMPRODUCT(--(MOD(A1:A10,2)=0),A1:A10)

odd

=SUMPRODUCT(--(MOD(A1:A10,2)=1),A1:A10)


--

Regards,

Peo Sjoblom

"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