One way:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
I am using the average function! But when there is no
data in the cells to
average it returns the #DIV?0! how can I avoid this I
would like it to be
blank
.