COUNTIF "EVEN" numbers in a range
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.
|