counting names

Posted by Patrick on April 02, 2001 7:48 AM

I have a list of names... B1:B30
all i would like to do
is to have a cell give me the total number
of names in the list
thanks in advance

Posted by Aladin Akyurek on April 02, 2001 7:49 AM

=================

=COUNTA(B1:B30)

Posted by Michelle on April 02, 2001 7:50 AM

For the total number of names:

=counta(B1:B30)

if you want a count of how many times a certain name appears:

=countif(B1:B30,"Name you want to see")

Posted by Stephen Giles on April 02, 2001 7:56 AM

Hi Aladin

Thanks for your answer re Index/Match. I still can't start a new thread on this message board for some reason is it because I have IE 4 do you think?

Stephen Giles

Posted by Patrick on April 02, 2001 7:57 AM

Thank you!!.......:)

Posted by Aladin Akyurek on April 02, 2001 9:03 AM

IE 4 should be fine, even iCab works...

: I have a list of names... B1:B30 : all i would like to do : is to have a cell give me the total number : of names in the list : thanks in advance

Stephen

You should use the form at the end of the page. Clicking on the one at the beginning of the page doesn't work for me either.

Aladin

Posted by Cosmo on April 02, 2001 9:41 AM

But what is I just want to know how many different names there are? Counta() counts how many names there are regardless of whether they appear once or more than once!

Posted by mseyf on April 02, 2001 10:58 AM

you'll need an array formula to count the unique values in a range.

enter the formula:
=SUM(1/COUNTIF(B1:B30,B1:B30))
and CSE (hold down the Ctrl+Shift keys and hit Enter) instead of just hitting Enter.

HTH

Mark : all i would like to do : is to have a cell give me the total number : of names in the list : thanks in advance