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.