Range Name Constants

[veryeavy]

Hi All,

I know you can define a range name to refer to a constant rather than a
range, but was hoping I could put more than one constant in there.

I have tried =OR("X","Y","Z") and ={"X","Y","Z"} and while the syntax is
fine it doesn't evaluate correctly in the formula i.e. I was hoping to see if
my text string matched one of the 3 items.

Any help would be much appreciated.

 

[Bob Phillips]

{"X","Y","Z"} is what works but you have to use it correctly, such as

=SUMPRODUCT(COUNTIF(A:A,array_of_constants))

--
HTH

Bob

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

 

[veryeavy]

A belated thanks, Bob.

It was my usage that was the problem.

Cheers.