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
|