DYnamic division of column sum by the number of entries

[jasonec]

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

[jasoncw]

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

=AVERAGE(A:A)

HTH

Jason