#Value!
Excel will ignore any empty cell (or any cell with text) in a formula like:
=sum(a1:a5)
So maybe you have an error in one of those cells.
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.
--
Dave Peterson
|