Hi,

"A7 is the sum of A1:A5 "

I think you had better show us the actual formula that is returning #VALUE
since the SUM function will not do this if a cell in the sum range is empty.
SUM does treat an empty cell as 0.

--
Thanks,
Shane Devenshire


"phowe43" wrote:

e.g., if A7 is the sum of A1:A5 but there is no character in cell A2, how can
I avoid the #Value! error without having to manually type in a "0" value. In
other words, the calculation does not recognize the blank cell as an
automatic "0" value.

I appreciate your help.