You can use the following generic function:

=IF(ISERROR(Formula),0,formula)

Where formula is the formula that you're currently using that produces the
#Ref error.
--
Kevin Backmann


"Franklin" wrote:

Guys,

I am collating reports and to create a summary I have to reference cells in
varoius daily reports from different sites. However if a report is missing
i.e the excel file is missing I get a #REF! value. This messes up all other
analysis I need to do on my data.
How can I get the cells to return the number zero instead of #REF!.

Cheers