Counting categories

This is most likely a question which has been asked before. If so let me apologise beforehand. (If it has been asked before I cannot find it)

I have a membership database of about 950 members.

There is a column headed 'Status'. This column can have 6 different entries.

How can I produce the count of each category? (as a Printed report)

i.e. AS = 2, SM = 628, SS = 187, LS = 123, LM = 10

I am using excel 2010

One of the multiple ways of solving your problem is a Pivot Table.
Have you tried it?

You could also explore from the main menu: Data (tab) > Outline (group) > Subtotal