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

One way:

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

In article <(E-Mail Removed)>,
"Sandy" <(E-Mail Removed)> wrote:

> 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

Thank you - simpler than I was expecting.
Sandy

"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> =AVERAGE(OFFSET(F16,,,A15,1))
>
> In article <(E-Mail Removed)>,
> "Sandy" <(E-Mail Removed)> wrote:
>
>> 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