Well that's a very different story from when you first asked the question,
but still wrong. If the cell is empty, you don't get a #VALUE! result. You
must have something in the cell, even if only a space. If you do have
something like a space, you can avoid the #VALUE! result by changing to a
SUM() function.
--
David Biddulph

"phowe43" wrote in message
...
Thanks all...it's a lengthy formula and there may have been an easier way
to
do it but I'm somewhat a novice. So here's the formula.

=(C8*'Data Tables'!B3+'Driver Input Form'!D8*'Data Tables'!C3+'Driver
Input
Form'!E8*'Data Tables'!D3+'Driver Input Form'!F8*'Data Tables'!E3+'Driver
Input Form'!G8*'Data Tables'!F3+'Driver Input Form'!H8*'Data
Tables'!G3+'Driver Input Form'!I8*'Data Tables'!H3)

So what happens is that C8 - D8 - E8 (etc.), are referencing a table with
defined values from a different page...and then I'm simply trying to total
the values. Again what happens is that unless there is some value
(including
a zero) in the cell (C8 - D8 etc.), I get the #Value! error.

Thanks again.

"ShaneDevenshire" wrote:

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.