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?