Excel: Average of the first 5 populated cells in Column A?

I have cell values AND empty cells in column A that could be anywhere within column A (column range from A1 to around A1000 - but maximum range can change) but the cell placements and the column range changes often, and so I would just need a formula or vba code for the: "Average of the first 5 populated cells in column A". I had a look as AverageIF, CountA, OFFSET, but just cannot work out how it would be possible. If someone could help I would really appreciate it. Regards,

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of August 17, 2014.

For more resources for Microsoft Excel