I’m scratching my head on a problem, I wanted to use multiple criteria in a COUNTIF formula but it seems I can’t… I’ve tried using SUMPRODUCT, but as I’m using text, not numbers it appeared to get confused.
Basically…
COLUMN C is one of 3 names; e.g. J SMITH, J BLOGGS, D DAVIS
COLUMD D is a priority; e.g. High, Medium, Low
I wanted to count how many of each priority are allocated to each of the names in Column C… E.G how many ‘highs’ does J SMITH have, how many mediums does ‘J SMITH’ have etc.
Any ideas as I’m really stuck and I’ve tried googling but they all say use SUMPRODUCT and I can’t get that to work.
1 Answer