Hi
as stated in your other post: Use a pivot table (this is what they were
made for). See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...simple-pivot-t
able/trackback/
--
Regards
Frank Kabel
Frankfurt, Germany
"Jim" schrieb im Newsbeitrag
...
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.