Function To Count All Strings In Range

[Budfudder]

I'm looking for a function that would count all of the different occcurrences of different strings within a range. It would go through an input range, cell by cell and, for each unique value it finds, it would count the number of occurrences of that value in the range.

So, for example, if I were to run it on this range:
Start.jpg

I'd get this result:
Result.jpg

Thanks in advance.

[Limor_OP]

How about uploading your excel file?

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[PeteABC123]

A pivot table would do that in a jiffy. Highlight your data, Insert. . .Pivot Table. ROWS. VALUES(use count of.)

Pete

[bebo021999]

Try with COUNTIF

=COUNTIF($A$1:$A$6,A8)