Which function do i have to use for counting only the names in one column ?

Hello everyone!

Good morning! So, here is my question that i need your help.

1) Which function do i have to use to count names of, for example companies? i have for example the name of that companies: Seaways,SharkWays,MonkeyWays,Universe,etc I found that i can do that with pivot table or the function counta, although counta, count the number of cells in a range that are not empty .

look at countif like =countif(range,name of company)
AND, depending on your computer settings it may be =countif(range to be counted; name of company)

I'm not really sure of you question. If you create a distinct list of the companies and point to them, say the list begins in cell C2 of the seven companies and the company list is in A2 through A100, then =COUNTIF($A$2:$A$100,C2) will count the number of times the company in C2 appears in your list.
to get a better, more complete answer you might have to post a sample workbook with sensitive/proprietary data removed and your expected results.
to post a sheet, use the "go advanced" button at the bottom right of this window, then midway down use the "manage attachments" then upload the sheet, hint it is easiest if you simply save the sample sheet to your desktop as that is the quickest way to get to it to attach it.

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Firstly, thank you for updating the title.

Try this:

=COUNTA(A2:A6)

If you want unique values:

=SUMPRODUCT(1/COUNTIF(A2:A6,A2:A6))

Thank you! i'll try next time to be more specific with my question and details as well.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

The SUMPRODUCT solution is for when you have a list of duplicates, but you wish to count unique values. If there are blanks in the range, you will need this:

=SUMPRODUCT(1/COUNTIF(A2:A6,A2:A6&""))