#DIV/0! means there are no numbers in the range you are tryng to average.
Make sure the range contains at least one number and check that values that
look like numbers actually are numbers (no leading apostrophes or extra
spaces).

If the range will contain no values until they are input, you may want to
use something like this:

=IF(COUNT(A1:A10)=0,"no data to average",AVERAGE(A1:A10))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"KhaVu" wrote:

I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
calculation.