I need to show a total for a series of values.
Some of these values may be replaced with "N/A" as a result of an IF formula.
When this happens, the total does not always calculate, which has a knock-on
effect for other formulas.

Any ideas?