A1 5
A2
A3
A4 3
A5
A6 1
A7
A8 9
A9

A few of the cells will contain numbers, however, many of the cells will be blank and some entire columns will be blank.

I have tried =Avg(A1:A10) and get the same #### answer when the entire column is blank.

Thanks.