Average of filtered data

From a list of data I can easily calculate the average:
=AVERAGE (A1;A250)

Then when I filter the data to keep only a selection of lines I would like
the average to automatically update.

How should I proceed?

Thanks for the help

Leave cell A251 blank and then on cell A252 type the followng:
=subtotal(1,A1:a250)

this will average the average of visible cells only
Also when using Auto-filter filter it for the range instead of the entire
column lest you should hide the average


"Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
news:0A5BE170-9865-4446-B350-5C483321307F@microsoft.com...
> From a list of data I can easily calculate the average:
> =AVERAGE (A1;A250)
>
> Then when I filter the data to keep only a selection of lines I would like
> the average to automatically update.
>
> How should I proceed?
>
> Thanks for the help
>

Try...

=SUBTOTAL(1,A1:A250)

Hope this helps!

In article <0A5BE170-9865-4446-B350-5C483321307F@microsoft.com>,
"Benjamin" <Benjamin@discussions.microsoft.com> wrote:

> From a list of data I can easily calculate the average:
> =AVERAGE (A1;A250)
>
> Then when I filter the data to keep only a selection of lines I would like
> the average to automatically update.
>
> How should I proceed?
>
> Thanks for the help

That does it!
Thanks for the help-

"N Harkawat" wrote:

> Leave cell A251 blank and then on cell A252 type the followng:
> =subtotal(1,A1:a250)
>
> this will average the average of visible cells only
> Also when using Auto-filter filter it for the range instead of the entire
> column lest you should hide the average
>
>
> "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
> news:0A5BE170-9865-4446-B350-5C483321307F@microsoft.com...
> > From a list of data I can easily calculate the average:
> > =AVERAGE (A1;A250)
> >
> > Then when I filter the data to keep only a selection of lines I would like
> > the average to automatically update.
> >
> > How should I proceed?
> >
> > Thanks for the help
> >
>
>
>