SUMPRODUCT with 3 critearia not adding up correctly

Joined
Mar 31, 2012
Messages
2
Reaction score
0
Hi, I did a search for this but could not find the answer I was looking for. I currently have a series of IF statements which includes:

,IF(F21="Kevin Guy",SUMPRODUCT(ISNUMBER(MATCH(Sheet1!$K$6:$K$2001,{"Kevin Guy"},0))+0,(Sheet1!$P$6:$P$2001="No Answer")+0,(Sheet1!$O$6:$O$2001="No Contact")+0), The next if statement follows on from this and the closing bracket is at the end of the formula.

The formula doesn't come up with any errors. However, it will still do a sum regardless if all 3 criteria are met or not. If only 1 criteria is met then it will still count "1" as opposed to "0".

Please can you tell me where I'm going wrong?

Thanks in advance,

Tim
 
Sorry, all works fine - I had moved the cell reference which 'IF' relates to and not updated the formula. My bad!

Thanks

Tim
 
Back
Top