Average- Expanding column length

[Sandy]

I have a range of data from A16 to K??.
In cell A15 I have a COUNTA function which returns the number of rows of
data (the range is continually being added to).

In F10 I would like to have an average function for the numeric values in
the Range(F16:F(whatever the COUNTA value is)+15). How can I do this?

Thanks
Sandy

 

[JE McGimpsey]

One way:

=AVERAGE(OFFSET(F16,,,A15,1))

 

[Sandy]

Thank you - simpler than I was expecting.
Sandy

One way:

=AVERAGE(OFFSET(F16,,,A15,1))