Try this:
=IF(ISERROR(your_formula),"",your_formula)
And another detail in your formula is that you don't need the SUM formula as you are not summing anything. The SUM formula should not give you any trouble if you for some reason like to put it there.
=SUM(A1*A2) is the same as =A1*A2
Bookmarks