COUNT FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of names in a column, I want to count how many names there are in the column.
 
Hi Cathy,

Here is an older CompuServe message that addresses your question.

Topic: Counting different value Msg #335156



To: Fiona Condon [received] 2 replies



From: Bill Manville 5:45 p.m. on 11-Aug-1999







Hi Fiona



<<

Is there a function that will count the number of different values in a
range? For example, if the range contained the values apples, oranges,
bananas, apples, oranges, bananas, apples, apples, apples, it would return 3
because there are 3 different fruit.



If List is the range,

=SUM(1/COUNTIF(List,List))

entered as an array formula with Ctrl+Shift+Enter



with acknowledgement to David Hager (I think) for a most ingenious solution.



Bill Manville

Oxford, England





Bill Manville was correct, David was the creator of the original solution.





Regards,

Kevin




CATHY said:
I have a list of names in a column, I want to count how many names there
Click to expand...
are in the column.
 
=counta(range)
where range, is your specific range address

CATHY said:
I have a list of names in a column, I want to count how many names there
Click to expand...
are in the column.
 
Whoops....didn't read the question properly.


Kevin Stecyk said:
Hi Cathy,

Here is an older CompuServe message that addresses your question.

Topic: Counting different value Msg #335156



To: Fiona Condon [received] 2 replies



From: Bill Manville 5:45 p.m. on 11-Aug-1999







Hi Fiona



<<

Is there a function that will count the number of different values in a
range? For example, if the range contained the values apples, oranges,
bananas, apples, oranges, bananas, apples, apples, apples, it would return 3
because there are 3 different fruit.



If List is the range,

=SUM(1/COUNTIF(List,List))

entered as an array formula with Ctrl+Shift+Enter



with acknowledgement to David Hager (I think) for a most ingenious solution.



Bill Manville

Oxford, England





Bill Manville was correct, David was the creator of the original solution.





Regards,

Kevin




CATHY said:
I have a list of names in a column, I want to count how many names there
Click to expand...
are in the column.
Click to expand...
 
If you simply want the total number of names:
1. Highlight the range of names.
2. In the toolbar at the bottom of the Excel worksheet,
right-click on "Num". This should bring up a menu.
Choose "Count" on the menu and the answer will appear in
the toolbar.

If the problem is more complex and you need to know how
many times a certain name appears, then use the CountIf
function. The equation looks like this:
=COUNTIF(A1:A10,"Cathy"). That equation will tell you how
many times the name "Cathy" appears in the range from cell
A1 to cell A10.

Cheers,
Scott
-----Original Message-----
I have a list of names in a column, I want to count how
Click to expand...
many names there are in the column.
 
Thank you...never knew that before, and appreciate your help,
but it doesn't display in the worksheet...
 
Back
Top