I have a spreadsheet with some information about Insurance policies in.

Basically each line within the spreadsheet represents a category, and each policy may have one or many categories.

One of the columns contains a value which is either a S, NS or VS

e.g

Pol No -- Cat Label -- Value
123----------------A-----------S
123----------------B-----------VS
445----------------A-----------NS
789----------------A------------S
789----------------B------------S

What I want to be able to do is to create a new table, with each policy number appearing once, and a count of how many categories that has which are S, how many are VS and how many NS

WOuld I able to do this would a combination of Vlookup and Countif, and if so how?

Thanks for looking