I'm trying to include a text search as one of the criteria in an Excel COUNTIFS function.
If I have the following formula.......
.....I want to replace F$2 with a search within the cell text for a specific substring.
For example, if cell F$2 contains the substring 'Error1' then the count will be incremented by 1.
I've attached a copy of my workbook.