tallying sales amounts

[jay-excel]

Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have four columns
B, D, E, G
<o> </o>
Column B = list of sales reps
Column D = sales amount product 1
Column E = sales amount product 2
Column G = sales amount product 3
<o> </o>
So, I have a list of sales for each sales rep for a given account. I am trying to automate or ease the process of tallying the total amount of sales for each sales agent.
After having made a sale, the sales rep enters their name, then the dollar amount of each item they have sold in the three columns. The list of sales becomes rather long.
<o> </o>
I am trying to have a total column or area that has the total sales amount for each sales rep for each product, then ultimately, their total sales (just a sum of the three). So, the total amount for Steve for product 1, then another total of product 2, and product 3. I have a set list of sales reps.
<o> </o>
I am open to all suggestions, be them formulas such as vlookup or index(match) or VBA code. I have tried tinkering with several different things, but usually I can only get the first sale of each sales rep to be taken from the list.
<o> </o>
Any help would be greatly appreciated. Thanks.

 

[Derek Brown]

You probably want to use the SUMPRODUCT function.
Have a look the the following web page - it gives a full description of the function:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Aladin Akyurek]

Create a distinct list of sales reps in column J.

J2, copy down:

=SUMIF($B$2:$B$100,$J2,$D$2:$D$100)

K2, copy down:

=SUMIF($B$2:$B$100,$J2,$E$2:$E$100)

L2, copy down:

=SUMIF($B$2:$B$100,$J2,$G$2:$G$100)

M2, copy down:

=SUM(J2:M2)