Sum of numbers associated with text

[MistyWind]

Hello. My data is structured as such below except I have hundreds of unique products. How can I tell how many items were purchased per product? My goal is to determine which products sold the most and how many units were purchased of each. Thanks in advance.

Product	How many purchased
Apple	2
Banana	2
Orange	1
Apple	1
Grapes	2
Grapes	1
Orange	4
Apple	3

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1	Fruit	Count		Fruit	Count
2	Apple	2		Apple	6
3	Banana	2		Orange	5
4	Orange	1		Grapes	3
5	Apple	1		Banana	2
6	Grapes	2
7	Grapes	1
8	Orange	4
9	Apple	3
10
Sheet9

Cell Formulas
Range	Formula
D2:E5	D2	=LET(a,UNIQUE(A2:A10),b,FILTER(a,a<>""),SORT(CHOOSE({1,2},b,SUMIFS(B2:B10,A2:A10,b)),2,-1))
Dynamic array formulas.

 

[MistyWind]

I feel like my question was a very simple one but it required such a complex formula. Either way, this worked out great. Thank you so much.