Forum Discussion
counting number of grade failures per student
Hello everyone, I need to count the number of Fs per student. How would I do this and have it calculate a "fail count" for each individual student? I also have to show this info on a pivot table. ...
For Sure
=COUNTIFS($A$2:$A$20,$A2;$F$2:$F$20,"F")COUNTIFS(ColumnWithStudents,StudentName,ColumnWithTheLetterResult,"F")
Juliano-Petrukio I tried to copy/paste this formula into the appropriate cell and I got this error...
Dont worry. I already updated the post including an attachment with the solution.