Hi,
I may be struggling with a first day back at work brain but I'm struggling to think of how to structure a formula.
What I need to do (Using the example attached) is count all the CAT3s but only from sites A,B and C. I need it to ignore D,E and F.
If I was doing it for a single site then it would just be
=COUNTIFS(B3:B25,"Site A",C3:C25,"CAT3")
But I want to widen the criteria in column B but ignore parts thereof.
This is just test example data and part of a larger formula but I'm struggling at the first part!
Bookmarks