How to Count/Add Occurences of a Item?

[ayahsoo]

Hello.
How do I count and report the number of occurances of a item?
I'm trying to do a report where I simply need to retrieve how many times each item occurs in the report and create a chart for that.
FOr example the output as follows:

Item
Apple
Orange
Mango
Orange
Orange
Mango
Apple

From the results above how do I get a report that says:

Item | Amount
Apple | 2
Mango | 2
Orange | 3

Total Fruits |7

(The "|" is my lame attempt at denoting a separate column )

Thanks for you help!

S

[Blake 7]

say your friut are in col a2 to a8 pu this in Col b cell c2 and drag dowm to a8

=COUNTIF($A$2:$A$8,A2)