Assuming that there are no error value in your data ranges,
=IF(denominator,formula,"")
or
=IF(denominator,formula,0)
depending on what you want returned when there is no matching data.

IF(ISERROR(formula),formula,"") as previously suggested will work, but
unnecessarily calculates the numerator an extra time.

Jerry

PW11111 wrote:

Hi

I have the following formula -

=COUNTIF(StatusCheck, "Snag Item")/COUNTIF(ElementCount,"Main Contractor -
Builderswork")

StatusCheck and ElementCount are named ranges.

The formula works - however when nothing is entered on the spreadsheet (the
formula has nothing to count) it displays #DIV/01.

Is there anything I can add to the formula to stop this happening?

Any help would be great.

Cheers,

Phil