#Value

[Todd]

I have a formula that is A1-sum(A2:A5) in cell A6. The
numbers in the range A1:A5 are contingent upon other cells
and have formulas that link them to these other cells.
When no data is available for these cells the #Value
appears in the cell. I have several rows with these
formulas and then an overall total of A66 in E6 but if
one cell in A66 has the #Value then E6 does not total.
How can I keep the #Value from appearing and allowing E6
to total? Thanks for the help.

Todd

 

[Charles Maxson]

Todd,

You can wrap 'error handling' around your functions like this in cells A1
thru A6:

=IF(ISERROR(B2),0,B2)

Of course you will substitute the B2 for the real cells...

 

[Bernard V Liengme]

Give us an example of the formulas in A2:A5.
Bernard