I have a simple data set:
Pupil A Teacher A pass Pupil B Teacher A fail Pupil B Teacher B pass
And want to compute the following statistics:
Teacher pass rate Teacher A 50% Teacher B 100%
The way I went about it is to create two columns with formulas,
=COUNTIFS(C:C,"pass", B:B, E2) / COUNTIF(B:B, E2).
Now, this works correctly but when creating a filter and ordering by pass rate, I got this:
- What am I missing? How to fix it?
- Is there a smarter and a better way to do this?