Change to:

=IF(AND(NOT(ISNUMBER(I7:AQ7))),"",AVERAGE(IF(ISNUM BER(I7:AQ7),I7:AQ7)))

--
Regards,
Dave


"carl" wrote:

I use this formula:

=AVERAGE(IF(ISNUMBER(I7:AQ7);I7:AQ7))

When there is no data in the range, the formula returns DIV/0. Is there a
way to modify the formula so that it returns """ instead of DIV/0.

Thank you in advance.