Averages Excluding empty cells

[Jerminator]

Ok, I have a Column containing empty cells and some with numbers. What I want to do is average those numbers excluding the empty cells in the average. Now this culumn changes on a monthly basis so, when I drop the info into this worksheet monthly, The blank cells will change rows, so looking for an automated process. I was thinking a IF statement, but not sure of the syntax. An example of what I want to accomplish:

A1: 10
A2:25
A3: Blank Cell
A4:10
A5:Blank Cell
A6:45
A7: 16


Elsewhere Formula to =sum (Data in cells/how many cells with data)

Not sure maybe Excel does this automatically.

 

[Oaktree]

=AVERAGE(A1:A10) will exclude blanks

 

[Jerminator]

kk, Thnx Oaktree

 

[shades]

try this:

=SUM(A1:A10)/COUNTIF(A1:A10,"<>0")

[EDIT: Sorry, this excludes zeroes, not blanks.]

 

[shades]

=AVERAGE(A1:A10) will exclude blanks

While this gives an average excluding blanks, it will include the zero, which may or may not be what the OP wants.