Countifs, wild card with cell reference

[Apple08]

Hi All

I have a formula: =IFERROR(COUNTIFS(Data!$Q:$Q,Dashboard!$B$19,Data!$A:$A,Dashboard!$B$23,Data!$I:$I,Dashboard!"*"&$D$20&"*"),0)

It doesn't work due to the wildcard with cell reference. I need to count D20 text either at the beginning, middle or at the end of the cell in Data!$I:$I

Please could anyone help? Many thanks.

 

[jasonb75]

You have the wildcard in the wrong place, it needs to be before the sheet name.

=IFERROR(COUNTIFS(Data!$Q:$Q,Dashboard!$B$19,Data!$A:$A,Dashboard!$B$23,Data!$I:$I,"*"&Dashboard!D$20&"*"),0)

 

[Apple08]

Excellent! It works perfectly, many thanks!