SOLVED

counting number of grade failures per student

New Contributor

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. 

7 Replies

@jklemm22 

Something like this?

 

JulianoPetrukio_0-1632517358778.png

 

@jklemm22 

See the attached version - it contains a pivot table.

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

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

best response confirmed by jklemm22 (New Contributor)
Solution

For Sure

 

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

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

 

JulianoPetrukio_0-1632525335828.png

 

 

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

jklemm22_0-1632525364663.png

 

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