Average of filtered data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Trying to find additional ranges outside of min, max, and average 2
Sumproduct in matrix means 3
Average every x cells 3
Insert Column, Keep Average range 1
Average of top x% of a list 1
in the worksheet, a1 to a10 have numbers. I want to calculate to a 2
Averaging data across a date range 1

Back
Top