Faulty Averaging Formula

[Phil H.]

In the averaged cells, AB31...AN31, it is possible they may all b
blank. Using the AVERAGE function returns the error #DIV/0!. Is ther
a way to have the below formula, located in cell Z31, enter a blank?
This formula still enters ther error. Or is there another construc
for the formula?


=IF((AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31)="#DIV/0!"),"",AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31)

 

[Toppers]

Phil,


Try ...

=IF((ISERROR(AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31))),"",AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31))

HTH

 

[Phil H.]

Hi Toppers,

That works! Thanks for the help.

Phi