SUMIF or SUMIFS help

R

RLD

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?
 
B

Bob Phillips

Try

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top