Adding multiple cells, return specific values
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.
|