counting number of grade failures per student

[jk22]

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. 

[#2]

@jk22 

Something like this?

[#3]

@jk22 

See the attached version - it contains a pivot table.

[#4]

@Hans Vogelaar 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?

[#5]

@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?

[#6 · Accepted solution]

For Sure

=COUNTIFS($A$2:$A$20,$A2;$F$2:$F$20,"F")

COUNTIFS(ColumnWithStudents,StudentName,ColumnWithTheLetterResult,"F")

[#7]

@Juliano-Petrukio I tried to copy/paste this formula into the appropriate cell and I got this error...

[#8]

Dont worry. I already updated the post including an attachment with the solution.