Sum of all even and odd numbers between two columns
 

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

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

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

--
HTH

Bob Phillips

"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

"Bob Phillips" wrote:
=SUMIF(A1:A10,"0")+SUMIF(B1:B10,"<0")
Not sure if this will return what the OP wants <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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" wrote in message
...
"Bob Phillips" wrote:
=SUMIF(A1:A10,"0")+SUMIF(B1:B10,"<0")
Not sure if this will return what the OP wants <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Is the definition of even and odd numbers in England

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


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