Countifs based on 'contains' but references a cell in table

[Melimob]

Hi I have the below formula

I basically want to count if the country in my current table appears within text in my country column in table1
Also since I want to absolute reference the PM, I've use $C$2 as I didn't know how to absolute reference the cell in a table if I just clicked on it. It would appear as ,[@Country] but then would try and move to next row if I copied down the formula.


=COUNTIFS(Table1[Country],"*[@Country]*",Table1[PM],$C$2)

I also want to use a similar count but add in a 3rd argument based on date which would be referenced on header row of both columns

thanks for any advice

 

[Melimob]

Hi I have the below formula

I basically want to count if the country in my current table appears within text in my country column in table1
Also since I want to absolute reference the PM, I've use $C$2 as I didn't know how to absolute reference the cell in a table if I just clicked on it. It would appear as ,[@Country] but then would try and move to next row if I copied down the formula.


=COUNTIFS(Table1[Country],"*[@Country]*",Table1[PM],$C$2)

I also want to use a similar count but add in a 3rd argument based on date which would be referenced on header row of both columns

thanks for any advice

OK got the 1st to work but had to reference range cell instead of table name

=COUNTIFS(Table1[Country],"*"&D3&"*",Table1[PM],$C$2)

now going to try and add in 3rd match