Hi,
I've run into a problem using countifs.
What i want the formula to do is look at 2 ranges and return a count but i want it to look for multiple values to count, not just one value.
i have attached a very simplified sheet of what i want to do. In the purple area i want to have a count of all the category A's and all the Category B's per person. So using this example attached 'jo's' count will be 4 cat A and 1 Cat B. Mark's count would be 4 Cat A and 0 Cat B. Deans counts would be 3 Cat A and 0 Cat B and so on......
Any help would be massively appreciated!
Kind regards
Richard
PS Forgot to add that what I kind of want is to embed an OR in my COUNTIFS to say so it totals up the count if the value is equal to this OR this OR this etc etc - Hope that makes sense. Is this possible?
Bookmarks