G
Guest
How do I count how many EVEN numbers in a range?
I tried =COUNTIF(B3:10,"EVEN") but no success.
I tried =COUNTIF(B3:10,"EVEN") but no success.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Johnson
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
G
Guest
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
=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
G
Guest
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?
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?
G
Guest
It's working....thanks a lot
Ken Johnson said:=SUMPRODUCT(--(MOD(B3:B10,2)=0))
Ken Johnson
I
iliace
There is ISEVEN() function, but for some reason it doesn't work on
arrays.
arrays.