Count the number of names in a column
Yes! That works great. Thank you!!
"Ron Coderre" wrote:
Try something like this:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
Adjust the range reference to suit your situation
Does that help?
***********
Regards,
Ron
XL2003, WinXP
"James" wrote:
I have a worksheet that lists names in one column. Is there a formula that'll
calculate the number of people represented? For example, column A lists:
Fred
Tony
Fred
Fred
Max
The five cells represent 3 people. I'm looking for a formula that'll tell me
the list represents 3 people.
Thanks for your help!
|