Create counter for combinations of cell matches within same row

[Gouldinho]

Hi All,



I'm trying to create a counter which identifies instances where for example "*P*" in column C and "Office" in D both occur in the same row. This counter would go in I21 in my attached screenshot.

For context, I know how to create counters, just not how to ask it to look for combinations from 2 cells within the same row.

This would obviously need to apply to the whole sheet.

I hope I've managed to explain this clearly and thanks in advance for any help!