| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT IF query
Hi,
I've been tring to add an extra IF statement into the following query but can't figure out how, what i want is for a count to be returned if cell A2 on sheet2 is the same as sheet1 where the M colunm in Sheet 1 = "on Time", but also where the N column on sheet1 = "EXEMPT". =SUMPRODUCT(--(Sheet1!M2:M11="On Time"),--(Sheet1!F2:F11=Sheet2!A2)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT IF query
try
=SUMPRODUCT(--(Sheet1!M2:M11="On Time"),--(Sheet1!F2:F11=Sheet2!A2)) =SUMPRODUCT(--(Sheet1!M2:M11="On Time"),--(sheet1!n2:n11="on time"),--(Sheet1!F2:F11=Sheet2!A2)) -- Don Guillett SalesAid Software "sdg8481" wrote in message ... Hi, I've been tring to add an extra IF statement into the following query but can't figure out how, what i want is for a count to be returned if cell A2 on sheet2 is the same as sheet1 where the M colunm in Sheet 1 = "on Time", but also where the N column on sheet1 = "EXEMPT". =SUMPRODUCT(--(Sheet1!M2:M11="On Time"),--(Sheet1!F2:F11=Sheet2!A2)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT/HLOOKUP Query | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Query | Excel Discussion (Misc queries) | |||
| Sumproduct Query | Excel Discussion (Misc queries) | |||
| I think its a sumproduct query? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT(-- Query for Tom Oglivy or others...... | Excel Discussion (Misc queries) | |||
Linear Mode
