Forum Discussion
Solved
Count Support?
Hi there, I'm assuming CountIf or CountIFS is potentially the right approach for this task. I trying to have excel read the name + a difficulty and return how many times the specific difficulty is r...
In B2:
=COUNTIFS($J$2:$J$10, $A2, $L$2:$L$10, B$1)
Fill down, then to the right (or vice versa).
You can use the COUNTIFS function to count occurrences of each difficulty level for each name.
Use this formula =COUNTIFS($E$2:$E$10, A2, $G$2:$G$10, B$1)
Drag the formula down and across to apply it for all names and difficulty levels.