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

To count each name just use:

=COUNTIF(C:C,"Brenda")

C:C is for the entire column so you can also enter a range like:

=COUNTIF(C2:C6,"Misty")

"B. Levien" wrote:

> 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
>

and, if you wanted to count all of them at once, you can do

=COUNTIF(C:E,"Brenda")

"stkinkuwait" wrote:

> To count each name just use:
>
> =COUNTIF(C:C,"Brenda")
>
> C:C is for the entire column so you can also enter a range like:
>
> =COUNTIF(C2:C6,"Misty")
>
> "B. Levien" wrote:
>
> > 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
> >