Mod a Formula For Errors

[Guest]

I'm trying to modify this formula so that it does the calculation even if
some of the cells in the ranges do not have "values (N/A or other errors).
Thanks you in advance.

=SUMPRODUCT(--($C$3:$C$216=I3);--($F$3:$F$216>0))/COUNTIF($C$3:$C$216;I3)

 

[Guest]

You can force it to be zero with an if statement like so:

=IF(ISERROR(SUMPRODUCT(--($C$3:$C$216=I3)--($F$3:$F$216>0))/COUNTIF($C$3:$C$216,I3)),0,SUMPRODUCT(--($C$3:$C$216=I3)--($F$3:$F$216>0))/COUNTIF($C$3:$C$216,I3))