Conditional Sum

  • Thread starter Thread starter Sherry
  • Start date Start date
S

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
 
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.
 
Back
Top