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)?