vlookup and countif to find the pertaining letter for each student

[N8DGR8]

I'm sure it's something simple, but it's just not coming to me. I'm assuming I need to combine a vlookup and countif so that i can get a result of how many A's L's or P's that each person has from the range in O1:P12 and place it next to their name in column N

any help would be appreciated, and if it will require VB, I'd rather even use a couple of formulas, that have to reference each other.

John		John	A
Mark		John	L
Yvette		John	P
		John	P
		Mark	A
		Mark	A
		Mark	L
		Mark	P
		Yvette	L
		Yvette	P
		Yvette	P
		Yvette	P

<tbody>
</tbody>

 

[AliGW]

Would be nice to know, though, having had the discussion.