Sum of all even and odd numbers between two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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
:
:
 
Back
Top