Sum of all even and odd numbers between two columns

[Oz]

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

 

[Max]

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)

 

[Bob Phillips]

=SUMIF(A1:A10,">0")+SUMIF(B1:B10,"<0")

 

[Max]

=SUMIF(A1:A10,">0")+SUMIF(B1:B10,"<0")

Not sure if this will return what the OP wants <g>

 

[Bob Phillips]

Hi Max,

Who knows what they actually want <vbg>. We have to overlay our assumptions
all the time, and the OP will probably never tell us

Bob

 

[Max]

.. and the OP will probably never tell us
Those that don't *could* be shy, you know <g>

 

[Lady Layla]

Is the definition of even and odd numbers in England

Even -- those over 0 and Odd - those below 0?


: =SUMIF(A1:A10,">0")+SUMIF(B1:B10,"<0")
:
: --
: HTH
:
: Bob Phillips
:
: : > 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
:
: