|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2009, 07:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Count Names
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 
|
|
#2
November 13th, 2009, 07:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Names
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
|
|
#3
November 13th, 2009, 07:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Names
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
