Countifs wildcards

Hi guys,

pLEASE CAN SOMEONE TELL ME how I can get my countifs on sheet2 to count wildcards from Bacon tab?

Cell C2 on sheet2 should count if column T says: 'to be coded' or 'will be coded'

How do I do that?

Tjank you

Formula:

Please Login or Register  to view this content.

Thank you both for your help both solutioons work!