Problem with formula

[Diving_Dan]

Hi all,

Having a few problems with a formula and hoping someone can help. I keep getting other as the result. If I remove the "or" portion of the formula along with two of the variables it works fine but as soon as I have them in it. Not sure what I'm doing wrong.

Thanks in advance

Dan

=IF(COUNTIFS(B24:B26,OR("EAST","WEST","SOUTH"),C24:C26,Lookups!A2)=1,"NOTED","Other")

 

[Fluff]

Try

       =IF(SUM(COUNTIFS(B24:B26,{"EAST","WEST","SOUTH"},C24:C26,Lookups!A2))=1,"NOTED","Other")

 

[Diving_Dan]

Thanks fluff, perfect

 

[Fluff]

You're welcome & thanks for the feedback.