Counting Cells with odd and/or even values

Y

yungexec

Lets say I have range A1:A5 containing values 1,2,3,4,5 respectively. I
would like to count how many of these cells are odd and place that value
in A6. The same for even numbers as well (in A7).

Any help would be appreciated.
 
R

Roger Govier

Hi

One way
=SUMPRODUCT(--(MOD(A1:A5,2)=1))
For even numbers, change the 1 in the formula to 0
 
B

Bob Phillips

Shame that ISEVEN doesn't work <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Roger Govier

Hi Bob

Yes, I played with that for a while but could not get a solution, so had
to resort to your favourite<g>
 
B

Bob Phillips

Oh it would still be SUMPRODUCT, but if you could do

=SUMPRODUCT(--(ISEVEN(A1:A5)))

that is so much more self-descriptive than using MOD. Unfortunately, the
ISEVEN function seems incapable of processing an array of values, just as
WEEKNUM cannot. Must be something to do with being an ATP function, I wonder
if it works with 2007 (must try it).

You could use

=SUMPRODUCT(--(EVEN(A1:A5)=A1:A5))

but I am not sure that that is any better than MOD

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top