SUMPRODUCT using IFERROR

[CR2515]

can someone walk me through a very basic example using sumproduct with iferror?

In the attached I get a N/A error in J13. What I'm trying to to do is sumproduct but in when column H has an error is replaces the field with a 0.

Thanks for the help.

 

[petertenthije]

I think you would be better of adding IFERROR formulas to the formulas in cells G2:H9 then to include it in the SUMPRODUCT formula.

 

[AhoyNC]

Is there a formula in your cost column that's producing the #N/A. If so, I would take care of the #N/A in that formula.
Something like (I'm assuming the cost column is H):

IF(ISNA(H2),0,what ever formula is in the cost column)

Your formula should work, but it needs to be entered as an array formula with CTRL-SHIFT-ENTER.