sumif using more than one criteria

[taniedzw]

I would like to know how to use the SUMIF function (or similar functio
that would work) to sum a column of data according to 3 other columns.

I have a column called "hours lost"
one called "vendor"
one called "problem type"
and one called "date"

basically the sum of hours lost for "vendor a" in month "january" i
one cell, then "vendor a" in month "February" and so on down th
column. then the sum of hours lost for "vendor b" for Month "january"
then "vendor c" for month "january" and so on down the row. I need t
fill up a spreadsheet for one year worth of that data.

one more problem, my date data is by day, not month but I need to plo
it by month

I already have the database set up with a form to enter all the data s
I don't believe a pivot table would work for me. Is there a formul
that can use multiple cirteria for SUMI

 

[RagDyer]

Column A = date
Column B = vendor
Column C = hours lost

D1 = number of month to lookup
E1 = vendor to lookup

Try this:

=SUMPRODUCT((MONTH(A2:A100)=D1)*(B2:B100=E1)*C2:C100)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I would like to know how to use the SUMIF function (or similar function
that would work) to sum a column of data according to 3 other columns.

I have a column called "hours lost"
one called "vendor"
one called "problem type"
and one called "date"

basically the sum of hours lost for "vendor a" in month "january" in
one cell, then "vendor a" in month "February" and so on down the
column. then the sum of hours lost for "vendor b" for Month "january",
then "vendor c" for month "january" and so on down the row. I need to
fill up a spreadsheet for one year worth of that data.

one more problem, my date data is by day, not month but I need to plot
it by month

I already have the database set up with a form to enter all the data so
I don't believe a pivot table would work for me. Is there a formula
that can use multiple cirteria for SUMIF

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MONTH(D1100)=2),--(YEAR(D1100)=2004),--(B1:B100="ven
dor a"),A1:A100)

but you may also consider using a pivot table for this. 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