Treat blanks as 0 and vice versa?

[ThomasCarter]

Is there a way to tell a formula/chart to treat 0's as blanks and vice versa?
For example I have a chart that averages the number of days late reports are. = AVERAGE(A1:A10)
(A4)=3 (A5)=2 (A7)=2 (A8)=2 (A10)=2 The rest are blank. The answer would be 2.2. However if the rest were 0's then the answer would be 1.1

I don't mind which method is possible I just need one of them for a reliable average regardless if there are 0's or not.

*All data is fictional for the example.

[daddylonglegs]

Yes AVERAGE normally ignores blanks, if you want blanks to be treated like zeroes try

=AVERAGE(INDEX(A1:A10+0,0))

[ThomasCarter]

Thanks a bunch, will try it first chance I get tomorrow.