COUNTIF "EVEN" numbers in a range
There is ISEVEN() function, but for some reason it doesn't work on
arrays.
On Sep 10, 5:08 pm, Udi14 wrote:
It's working....thanks a lot
"Ken Johnson" wrote:
On Sep 11, 6:44 am, Udi14 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 -
|