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.
I have attached a small example datasheet.
I actually need to perform this function for several hundred students.
I tried to use countif and subtotal feature but could not get that to work with the pivot table that I need to show this data on. Any help is appreciated.
For Sure
=COUNTIFS($A$2:$A$20,$A2;$F$2:$F$20,"F")COUNTIFS(ColumnWithStudents,StudentName,ColumnWithTheLetterResult,"F")
7 Replies
See the attached version - it contains a pivot table.
HansVogelaar yes, this works great for the pivot table part - but is there a way to formulate this in the column next to the letter grade?
Juliano-Petrukio yes, this works great for the pivot table part - but is there a way to formulate this in the column next to the letter grade?
For Sure
=COUNTIFS($A$2:$A$20,$A2;$F$2:$F$20,"F")COUNTIFS(ColumnWithStudents,StudentName,ColumnWithTheLetterResult,"F")
