View Single Post
  #1   Report Post  
Jim
 
Posts: n/a
Default 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.