Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I write a formula that will add all the sales for an individual,
return the name in one cell and the total sales in another and list them by highest dollar sold descending? Example of what I will enter into Excel: Jim $100.00 Jim $126.78 Jim $153.56 Rose $180.34 Rose $207.12 Rose $233.90 Rose $260.68 Rose $287.46 Bill $314.24 Bill $341.02 Bill $367.80 Bill $394.58 Bob $421.36 Bob $448.14 Bob $474.92 Bob $501.70 Bob $528.48 Bob $555.26 This is what I would like the results to look like: Bob $2,929.86 Bill $1,417.64 Rose $1,169.50 Jim $380.34 Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Adding muliple cells. | Excel Worksheet Functions | |||
ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions |