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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top