Average of filtered data

B

Benjamin

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
 
N

N Harkawat

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
 
B

Benjamin

That does it!
Thanks for the help-

N Harkawat said:
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
Click to expand...
 
Top