One strategy is to change the formulas that are returning #VALUE to an
IF statement, maybe something like this:
=IF(ISERROR(your formula here),"",your formula here)

This evaluates the formula and returns nothing if the formula returns
an error, but returns the formula's result if it is not an error.