Thank you, It worked and is shorter.

"Shane Devenshire" wrote:

Hi,

Why not just

=IF(ISERR('Other Occupancies'!C13),0,'Other Occupancies'!C13)

or in 2007

=IFERROR('Other Occupancies'!C13,0)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Niek Otten" wrote:

=IF(ISERROR(SUM('Other Occupancies'!C13)),0,SUM('Other Occupancies'!C13))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Codeman" wrote in message
...
When a cell is showing; #VALUE!
Because the amount has not been calculated how can I get it to just show
zero (0)

I am getting the value from other spreadsheets totals and when those
totals
are not completed, because they are not applicable, I would like the final
tabulation worksheet to just put 0 automatically there. I do not want to
change the other worksheets from where the totals area coming from.

=SUM('Other Occupancies'!C13) is the formula in one of the cells on my
last
spreadsheet and I want it to be showing zero (0) instead of #VALUE!

Can it be done to just show 0 (zero)?