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.
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.