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

M

michaeltiang

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
 
M

Max

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.
 
S

Stu Gnu

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
Data>Consolidation
Select the array
Tick 'Left Column' box in 'Use Labels in'
Select 'Add'
OK'

The result will show a table with consolidated totals
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top