Try this array formula
=SUM(IF(ISNA(A1:A8),0,A1:A8))
remember to complete it with SHIFT+CTRL+ENTER not just ENTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Robojohn" wrote in message
...
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?