Hi
I have this formula which works
=COUNTIFS(Table1[[Country]:[Country]],"*"&$B184&"*",Table1[[POA / Clients]:[POA / Clients]],"<>*ABC*",Table1[[POA / Clients]:[POA / Clients]],"<>*TBC*")
but the last condition that I want to add is searching a number of columns and it returns "VALUE" error...