|
Posted to microsoft.public.excel.misc
|
|
|
sum of similar products
Use a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
In article ,
dcs68 wrote:
In Excel 2007, how would I go about getting totals for similar values? For
example, I have 2 coulmns in a sheet. 1 contains the sales reps name and the
2nd contains the sales on a particular invoice. I want to get sales totals by
rep.
Thanks,
Derek
|