Conditional COUNTIF

[Sara]

What is wrong with this formula

IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F")

 

[Simon Lloyd]

What is wrong with this formula

IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F")You can't use the OR operator like that you need to use an array like

this:
=IF(COUNTIF($AQ2:$BB2,{"ABC","DEF"}),"T","F")


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Simon Lloyd]

You can't use the OR operator like that you need to use an array like
this:
=IF(COUNTIF($AQ2:$BB2,{"ABC","DEF"}),"T","F")Ignore that rubbish i just sent you - don't know why i did that, its

early hours of the morning here, use this:
=IF(OR(COUNTIF($AQ2:$BB2,"ABC"),COUNTIF($AQ2:$BB2,"DEF")),"T","F")


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[T. Valko]

Try it like this:

=IF(SUM(COUNTIF($AQ2:$BB2,{"ABC","DEF"})),"T","F")

 

[Max]

Here's one alternative which serves your underlying intents:
=IF(SUMPRODUCT(--ISNUMBER(MATCH($AQ2:$BB2,{"ABC","DEF"},0))),"T","F")
Success? Pl click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik