Forum Discussion
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 reflected within a set of data (Hard, Medium, Easy).
I've provided an example attached to support. Thank you for any suggestions!
In B2:
=COUNTIFS($J$2:$J$10, $A2, $L$2:$L$10, B$1)
Fill down, then to the right (or vice versa).
4 Replies
With modern Excel you may use
=PIVOTBY($K$1:$K$10, $M$1:$M$10, $L$1:$L$10,COUNT,,0,,0)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.
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.
In B2:
=COUNTIFS($J$2:$J$10, $A2, $L$2:$L$10, B$1)
Fill down, then to the right (or vice versa).
