Hi!

Here's one way:

=IF(COUNT(F3:F124)=0,"",A1/COUNT(F3:F124))

Biff

-----Original Message-----
I have a formula like this =A1/COUNT(F3:F124)
When cells F3:F124 are emty, my formula returns #DIV/0!
Can that be made a blank cell instead of #DIV/0! ?

rgd Bill Gras
.