running avg formula that ignores blanks

[Happy]

I am attempting to build a formula that averages a column of data (that gets
added to every day), but ignores, or does not include blank rows.
Any hints?

 

[JE McGimpsey]

One way:

=AVERAGE(A:A)

 

[Happy]

I'm not sure I understand this........ possible to give an example?

 

[Dave Peterson]

Put your numbers in column A.

Empty some cells.

Put that formula in B1.

You'll see that =average() ignores text and empty cells.