Faulty Averaging Formula
 

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 )

--
Phil H
-----------------------------------------------------------------------
Phil H.'s Profile: http://www.hightechtalks.com/m22
View this thread: http://www.hightechtalks.com/t228156

Faulty Averaging Formula
 

Phil,


Try ...

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

HTH

"Phil H." wrote:


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


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


--
Phil H.
------------------------------------------------------------------------
Phil H.'s Profile: http://www.hightechtalks.com/m229
View this thread: http://www.hightechtalks.com/t2281562

Faulty Averaging Formula
 

Hi Toppers,

That works! Thanks for the help.

Phi

--
Phil H
-----------------------------------------------------------------------
Phil H.'s Profile: http://www.hightechtalks.com/m22
View this thread: http://www.hightechtalks.com/t228156