Thread
:
COUNTIF "EVEN" numbers in a range
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ken Johnson
external usenet poster
Posts: 1,073
COUNTIF "EVEN" numbers in a range
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
Reply With Quote
Ken Johnson
View Public Profile
Find all posts by Ken Johnson