Is there a formula that will return a value of "0" if referencing a
cell that has "#Ref" in it?

In other words something like ISNA for #Ref. I have several tables
that are linked to a summary page. The tables pull from an SQL back
end and depending on the query may return no values. When this happens
the summary pages errors because of a #Ref error (ie. no data).

Any ideas out there?

Thanks all,

Steve Monczka