Excel - How to select the last x entries in a column?

[dulas david]

Can anyone help with this. I need to be able to select the last 12 (variable) entries in a column in an Excel worksheet. These entries need to be totalled and the average then worked out. Any ideas?

Thanks,

David