Using a Wildcard in a Table COUNTIF

[music_al]

Hi

I'm trying to do a COUNTIF in a table that refers to another table, looking for any cell in the RRAR table that contains the text in the field Agency_Name of another table.

The cell in the table is...

=COUNTIF(RRAR[RRAR_Issued_To],*[@[Agency_Name]]*)

It doesnt work with or without the wildcard.

Thank you in advance

Al

 

[AlphaFrog]

Try this syntax...

=COUNTIF(RRAR[RRAR_Issued_To],"*" & [@[Agency_Name]] & "*")

 

[music_al]

That works great Frog. Thank you.