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?

The cells in the separate worksheets may contain a blank space, as if
someone typed just the space bar and pressed return. That cell would
look blank, visually, but Excel would evaluate it as a text entry and
return the VALUE error because Excel doesn't perform math on a text
string (without some extra manipulation).

Inspect the "foreign" cells and if they appear to be blank or SHOULD be
blank, land the cell pointer on that cell and press the Delete key.
That will remove any entry in that cell and allow Excel to perform math
on a blank cell, which it will do.

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?