SOLVED

New Contributor

# 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.

7 Replies

# Re: counting number of grade failures per student

Something like this?

# Re: counting number of grade failures per student

See the attached version - it contains a pivot table.

# Re: counting number of grade failures per student

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

# Re: counting number of grade failures per student

@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 jk22 (New Contributor)
Solution

# Re: counting number of grade failures per student

For Sure

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

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

# Re: counting number of grade failures per student

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

# Re: counting number of grade failures per student

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