Using 'OR' with validated data

J

Jayjay

I'm having a problem with, what I'm sure will turn out to be, a simple problem.

I have a validated list in one file, which is 20 columns of "Yes" or "No".

All I want to do in another file is say:

If any of the columns have "Yes" selected then return a TRUE response - a
simple 'OR' formula I thought.

However, if the "Yes" is in any column other than the first in the formulas
sequence, it returns a FALSE response.

Any ideas as to why it's not picking up the other columns correctly?

Thank you.
 
B

Bob Phillips

=COUNTIF(A1:T1,"Yes")>0

--
HTH

Bob Phillips

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