One way

Put in C1:
=SUMPRODUCT(--(MOD(A1:A10,2)=0),A1:A10)
(add even numbers in col A)

Put in D1:
=SUMPRODUCT(--(MOD(B1:B10,2)=1),B1:B10)
(add odd numbers in col B)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Oz" wrote in message
...
I have column "A," and "B," with random numbers listed. I need a formula
to
add just the even numbers in column "A," and all the odd numbers in column
"B." I.E.(Range A1:A10 & B1:B10)

Help!

Oz