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? 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: Jim $380.34 Rose $1,169.50 Bill $1,417.64 Bob $2,929.86 Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Adding cells from multiple workbooks | Excel Discussion (Misc queries) | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |