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.