Need help with Countif with vlookup!

Originally Posted by Rajesh CR

Guy,

I have a list of names and each of the have got, the below rating. Now I want to count the number of Excellent, Good, Neutral etc. in the result page. Please help.

1) Excellent
2) Good
3) Neutral
4) Fair
5) Poor

Attached is the excel sheet. Your help is much appreciated.

Hi Rajesh,

A version using pivot tables.
You need to rearrange the data slightly.
Please see attached.