How do I count how many EVEN numbers in a range?
I tried =COUNTIF(B3:10,"EVEN") but no success.

On Sep 11, 6:44 am, Udi14 <Ud...@discussions.microsoft.com> wrote:
> How do I count how many EVEN numbers in a range?
> I tried =COUNTIF(B3:10,"EVEN") but no success.

=SUMPRODUCT(--(MOD(B3:B10,2)=0))

Ken Johnson

Try this:

=SUMPRODUCT(--(MOD(B3:B10,2)=0))

Note that this will treat blank cells as even numbers. If you want blanks
to be excluded then try:

=SUMPRODUCT(--(MOD(B3:B10,2)=0),--(ISBLANK(B3:B10)=FALSE))

HTH,
Elkar


"Udi14" wrote:

> How do I count how many EVEN numbers in a range?
> I tried =COUNTIF(B3:10,"EVEN") but no success.

Thanks but it seems complicated....if u take a simple range of numbers like
1, 4, 6, 11, 15, 18.....i should be able to countif 3 EVEN numbers
(4,6,18)...its so simple yet Excel does not allow to define "EVEN" in a
formula?

"Elkar" wrote:

> Try this:
>
> =SUMPRODUCT(--(MOD(B3:B10,2)=0))
>
> Note that this will treat blank cells as even numbers. If you want blanks
> to be excluded then try:
>
> =SUMPRODUCT(--(MOD(B3:B10,2)=0),--(ISBLANK(B3:B10)=FALSE))
>
> HTH,
> Elkar
>
>
> "Udi14" wrote:
>
> > How do I count how many EVEN numbers in a range?
> > I tried =COUNTIF(B3:10,"EVEN") but no success.

It's working....thanks a lot

"Ken Johnson" wrote:

> On Sep 11, 6:44 am, Udi14 <Ud...@discussions.microsoft.com> wrote:
> > How do I count how many EVEN numbers in a range?
> > I tried =COUNTIF(B3:10,"EVEN") but no success.
>
> =SUMPRODUCT(--(MOD(B3:B10,2)=0))
>
> Ken Johnson
>
>

There is ISEVEN() function, but for some reason it doesn't work on
arrays.


On Sep 10, 5:08 pm, Udi14 <Ud...@discussions.microsoft.com> wrote:
> It's working....thanks a lot
>
>
>
> "Ken Johnson" wrote:
> > On Sep 11, 6:44 am, Udi14 <Ud...@discussions.microsoft.com> wrote:
> > > How do I count how many EVEN numbers in a range?
> > > I tried =COUNTIF(B3:10,"EVEN") but no success.
>
> > =SUMPRODUCT(--(MOD(B3:B10,2)=0))
>
> > Ken Johnson- Hide quoted text -
>
> - Show quoted text -