sum of similar products
 

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

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