DYnamic division of column sum by the number of entries

Hello all,

Quick question from an amatuer. I want to sum a column that may have infinite entries and then divide the sum by the total number of entries (even if the entry is zero).

Can anyone help?

Thanks,

JC

This will average the entire column A for all entries, including 0 values, but it will exclude blank cells:

=AVERAGE(A:A)

HTH

Jason