SUMIF or SUMIFS help
 

I have 2 sheets in one workbook (Sheet 1 and Sheet 2)

Sheet 2 has 3 columns:
A B C
MAKE TYPE QTY

1 toyota compact 10
2 ford pickup 15
3 toyota sedan 20
4 toyota pickup 80
5 nissan hybrid 10

Sheet 1 has 2 columns:
A B
MAKE PICKUPS

1 toyota ? (SUM)

I need Sheet 1,B1 to calculate the total number of matching items in sheet 2
that matches the data entered in Sheet 1,A1. In other words, I need sheet
1,B1 to automatically sum up the total number of toyota pickups in sheet 2.
Can anyone help me with the formula to accomplish this?

SUMIF or SUMIFS help
 

Try

=SUMPRODUCT(--(Sheet2!$A$2:$A$200=A2),--(Sheet2!$B$2:$B$200="pickup"),Sheet2!$C$2:$C$200)

--

HTH

Bob

"RLD" wrote in message
...
I have 2 sheets in one workbook (Sheet 1 and Sheet 2)

Sheet 2 has 3 columns:
A B C
MAKE TYPE QTY

1 toyota compact 10
2 ford pickup 15
3 toyota sedan 20
4 toyota pickup 80
5 nissan hybrid 10

Sheet 1 has 2 columns:
A B
MAKE PICKUPS

1 toyota ? (SUM)

I need Sheet 1,B1 to calculate the total number of matching items in sheet
2
that matches the data entered in Sheet 1,A1. In other words, I need sheet
1,B1 to automatically sum up the total number of toyota pickups in sheet
2.
Can anyone help me with the formula to accomplish this?