SUMPRODUCT with 3 critearia not adding up correctly

[Timmytim]

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

 

[Timmytim]

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

Thanks

Tim