validation zero

[Devlin]

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

 

[Anne Troy]

=countif(range,>0)
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[Bob Phillips]

Typo Anne.

=COUNTIF(rng,">0")

--
HTH

Bob

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