SUMPRODUCT IF query

G

Guest

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))
 
D

Don Guillett

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))
 

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

Similar Threads

Conditional Sumproduct 0
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Conditional sum in a named range 8
SUMPRODUCT 7
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Range(sheet2) = Range(sheet1) 11
vlookup + if formula help! 7

Top