How to total words

S

Simone

I have a spreadsheet with two columns like below.
I'd like to get a total of column B. For instance, Apple=4, Mango=2,
Pineapple=1/
Is this possible?

Orchard Fruit
A Apple
A Mango
B Apple
B Mango
C Pineapple
D Apple
E Apple
 
L

~L

Yes.

In C2:

=Countif($B$2:$B$500,B2)

And drag down

Or, create a summary table below or to the right of your data using advanced
filter, copy uniques to another location, then replace B2 with the location
of the top item of the summary table and drag down.
 
S

Simone

Thanks for the answer, it works perfectly.

~L said:
Yes.

In C2:

=Countif($B$2:$B$500,B2)

And drag down

Or, create a summary table below or to the right of your data using advanced
filter, copy uniques to another location, then replace B2 with the location
of the top item of the summary table and drag down.
Click to expand...
 
Top