If you have formulas in the cells that you are adding, and perhaps some of
those formulas are set to return nulls, you could get that #Value! error.

However, if your summing formula *doesn't* use SUM(), you could try to
revise it to SUM(), since SUM() ignores text, spaces, and nulls ( "" ).

If you're already using SUM(), and you're receiving the #Value! error, that
means that one of the cells you're totaling is returning that error itself.
In that case, you should correct the formula in the cell that's creating the
error message in the first place.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Luke" wrote in message
...
I have a formula which sums 2 or more cells in a separate worksheet.
However
if any of these cells are blank the formula returns a '#VALUE'. Bizarrely
the
same formula into a different worksheet does not cause this error message.

Any idea's other than a long IFISERROR formula?