Conditional Sum

[Sherry]

i have the following data:

item1 salesman1 30 units
item1 salesman2 10 units
item1 salesman3 11 units
item2 salesman1 1 unit
item2 salesman3 5 units
item3 salesman4 22 units
item3 salesman5 50 units

I want to find the total sales of each item in the fourth
column.

How do i do it?

SOS
Sherry

 

[matmich]

try this =sumif($a$1:$a$5,a1,$c$1:$c$5

 

[Serkan Gur]

You have to use =sumif() function and the Conditional Sum
Wizard will automatically do that for you when you just
follow its steps. If you can't find the wizard in your
Excel menu, you have to add it in from the Excel menu
from Tools/Add-ins and then clicking the wizard.

 

[Frank Kabel]

Hi
you received some answers using SUMIF (a formula approach). Depending
on the volume of you data you may consider using a pivot table. See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
for instructions how to use them. This will create a report nearly
automatically