Typo Anne.

=COUNTIF(rng,"0")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anne Troy" wrote in message
...
=countif(range,0)
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Devlin" wrote in message
...
Hello. I have this small problem concerning the validation of the values
the
users can enter in a table: the source list contains several cells than
aren't usually filled wiith values, therefore the validation treats them
as
0. They come as a formula with reference to another sheet, so that's why
I
believe the option "Skip blanks" does not work. The problem is some
operations in my table involve the COUNTA formula, and everytime a user
mistakenly enters 0 (from the drop down list created by the validation),
this
0 value is counted and messes up my things there. How do I get rid of
these 0
values?

Thanks,
Devlin