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).
This is the formula in the solution workbook below: =COUNTIFS($J$2:$J$10,$A$2:$A$4,$L$2:$L$10,$B$1:$D$1)
I think this is one way to your solution. Spilling in this case is quiet useful since dragging left and right will change things and make you get zeros 0 as counts. Thanks and i hope you find this useful.