Try something like this...

The formula won't calculate an average until at least 1 number is entered in
the range.


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


--
Biff
Microsoft Excel MVP


"Vince" wrote:

How do I average a range of cells that are blank until data is entered later
with out the destination cell returning a #div/o! error