| 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.
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) | |||
Hybrid Mode
