| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display result in same cell as formula | Excel Discussion (Misc queries) | |||
| how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
| Display adjacent cell as result... | Excel Discussion (Misc queries) | |||
| display the cell that produced a result | Excel Discussion (Misc queries) | |||
| How can I display a result as a cell name? | Excel Discussion (Misc queries) | |||
Linear Mode
