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

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.