Want to add value from a range and display result in a cell.
 

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

Want to add value from a range and display result in a cell.
 

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

Want to add value from a range and display result in a cell.
 

Try this:

=SUMIF(A1:A5,"Apple",B1:B5)

Or:

D1 = Apple

=SUMIF(A1:A5,D1,B1:B5)

--
Biff
Microsoft Excel MVP


"michaeltiang" wrote in message
...
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

Want to add value from a range and display result in a cell.
 

You could use Consolidate in the Data menu, as follow:

Place the cursor in the cell where you want the consolidated data to appear
Using the main menus
DataConsolidation
Select the array
Tick 'Left Column' box in 'Use Labels in'
Select 'Add'
OK'

The result will show a table with consolidated totals


"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