validation zero
 

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

validation zero
 

=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

validation zero
 

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