One quick option is to use a pivot table (PT). It can do 2 things for you in
a matter of seconds with a few clicks/drag n drops: produce a uniques listing
of the fruits and add up the amounts per fruit.

Assume table like below, with col headers "Fruit" and "Amount"

Fruit Amount
apple 50.00
apple 10.00
cherry 20.00
pineapple 30.00
apple 20.00
etc

Select a cell within the table. Click Data Pivot table .. Click Next
Next. In step 3 of the wizard, click Layout. Drag n drop "Fruit" within the
ROW area. Drag n drop "Amount" within the DATA area. Click OK OK Finish.
That's it. Hop over to the PT sheet for the results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"michaeltiang" wrote:
Please help me..
i got a range with certain data and i need to count the cell with same item
and display the total price in a new cell . Example

apple 50.00
apple 10.00
cherry 20.00
pineapple 30.00
apple 20.00
and i want display the total sum value of apple (which is 80.00 in another
cell)

plz help