Average- Expanding column length

  • Thread starter Thread starter Sandy
  • Start date Start date
S

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
 
Back
Top