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" wrote in message
...
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 ,
"Benjamin" 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" wrote in message
...
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