How to total words
 

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

How to total words
 

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.

"Simone" wrote:

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

How to total words
 

Thanks for the answer, it works perfectly.

"~L" wrote:

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.

"Simone" wrote:

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