|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 11th, 2010, 11:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
March 12th, 2010, 12:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
