View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Udi14 Udi14 is offline
external usenet poster
 
Posts: 3
Default COUNTIF "EVEN" numbers in a range

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