Hi
try
=IF(COUNT(A1:A20),AVERAGE(A1:A20),"no cells filled")

--
Regards
Frank Kabel
Frankfurt, Germany

"ucastores" schrieb im
Newsbeitrag ...
i am trying to average a range of cells, in different spreadsheets
within one
worksheet but it gives me the error #div/0 when one of the cells is
blank.
Any suggestions, thoughts, comments?