Count Names

[B. Levien]

I have an excel spreadsheet with Columns like:
Column C Column D Column E
Award1 Award2 Award3
Row 1 Brenda Joe Shana
Row 2 Misty Joe Monty
Row 3 Brenda Misty Monty
Row 4 Brenda Misty Janice
Row 5 Frederique Joe Monty

Is there any way to count the number of each name in a colum?

E.G.

C1:C5 Brenda counts as 3, Misty counts as 1, Frederique counts as 1
C1-C5 Joe counts as 3, Misty counts as 2
D1-D5 Shana counts as 1, Monty counts as 3 and Janice counts as 1

 

[B. Levien]

Sorry, I meant to post this in Excel, and can't delete from here.

B.

 

[anamque]

You can do =countif(range,criteria)

=countif(c1:c5,"brenda")