Finding text in a cell

[Tom_Fernley]

Hello everyone,

Really sorry, but the search function isn't working for me at the moment, so if these answers are elsewhere, apologies...

In the attached file, I need to count the total number of tours and inspections, planned vs. actual, across the year. What I'm stuck on is finding occurrences of a given set of initials when they're part of a larger text string.

I can make sure that the initials are always delimited with hyphens (or any other character), with no spaces. I'd like to avoid large tracts of hidden rows and columns, if possible.

Thanks,


Tom