Average Issues??? one, average, least, count

andy

My formula is =AVERAGE(A1:A5). When all cells (A1:A5) are empty, my answer is #DIV/0!. How do I make #DIV/0! = empty cell?

=if(count(a1:a5),average(a1:a5),"")

A few options... one would be to check that the range contains at least one numerical value:

=IF(COUNT(A1:A5),AVERAGE(A1:A5),"")

EDIT: above is an exact copy of excelR8R's post!