=COUNTIF(D2:D567,0)


--
Regards,

Peo Sjoblom




"Ardy" wrote in message
ps.com...
Hello All:
OK I am a bit confused. I have a bunch of data, Column D has various
digits that signify different things fore example 0 = Apple 10 =
Orange. I am doing a simple count [=COUNT(D2:D567,0)] to get a count
of 0's instead I get the count of all data which sums up to be 567.
what Am I doing wrong

Ardy