Can somebody help me with an if iserror problem

[irenesboy]

I have the below formula that I would like to add the IF(ISERROR function to.

I have been struggling with for 3 hours.

if it produces an error i would like the cell to be blank.

Thanks in advance.

please help.


=SUMPRODUCT((Data!$C$2:$C$10989=$M25)*(Data!$B$2:$B$10989=$L24)*(Data!$I$2:$I$10989))


irenesboy

 

[Luke M]

If using 2007:

=IFERROR(SUMPRODUCT((Data!$C$2:$C$10989=$M25)*(Data!$B$2:$B$10989=$L24)*(Data!$I$2:$I$10989)),"")


Else:

=IF(ISERROR(SUMPRODUCT((Data!$C$2:$C$10989=$M25)*(Data!$B$2:$B$10989=$L24)*(Data!$I$2:$I$10989))),"",SUMPRODUCT((Data!$C$2:$C$10989=$M25)*(Data!$B$2:$B$10989=$L24)*(Data!$I$2:$I$10989)))


I would note that it might be better to determine what is causing the error and try to avoid that, rather than "covering" it at the end.