Average- Expanding column length

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 16 Aug 2007 14:48 GMT

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

Reply to this Message

JE McGimpsey - 16 Aug 2007 14:58 GMT

One way:

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

> 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
[quoted text clipped - 5 lines]
> Thanks
> Sandy

Reply to this Message

Sandy - 16 Aug 2007 15:28 GMT

Thank you - simpler than I was expecting.
Sandy

> One way:
>
[quoted text clipped - 9 lines]
>> Thanks
>> Sandy

Reply to this Message