using sumif function with mutliple criteria

[Guest]

I have a spreadsheet with three columns:Labor Code, Dollar Amount,
Cost Center

I need to sum the labor codes within each cost center.
The sumif statements needs to meet two criteria.

 

[Alan]

With the labour code in column A and the Dollar Amount in column B try
=SUMPRODUCT((A1:A100= "Your Labour Code")*(B1:B100))
"Your Labour Code" being the actual code you want to sum,
Regards,

 

[Guest]

Let me clarify: I must sum each Labor Code within each Cost Center.
There are 7 different Cost Centers with 10 different Labor Codes that could
be used in each Cost Center.

 

[Alan]

OK, With the labour code in column A, the Cost Centre in colun B and the
Dollar Amount in column C
=SUMPRODUCT((A1:A100= "Your Labour Code")*(B1:B100="Your Cost
Centre")*(C1:C100))
"Your Labour Code" And'Your Cost Centre" being the actual codes you want to
sum,

 

[Frank Kabel]

Hi
as alternative 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
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[dave22q]

kind of brute force but simple way is to create col for each of the 7
subtotals you need. in ea col use an if statement to only enter item
which fit that row hen use sum function to total the cols.. should b
fairly easy to report in a 7x 10 table format. eg. if a1=4 and b1=5 ar
the codes we want for a particular cell the if statement would be
if(a1/4*b1/5=1,c1,0)

 

[Myrna Larson]

Just curious, but is there some reason you are avoiding AND, i.e.

=IF(AND(A1=4,B1=5),C1,0)