Averaging from a cell to the bottom of the list

  • Thread starter Thread starter AAS
  • Start date Start date
A

AAS

I have a list of numbers from G11 to G94 but I also am also using a filter in
other columns therefore I would like the average to change if I decide to
filter.
Basically I want the average to always be from the first number to the
bottom number but the last cell will change due to me using the filter option.
 
Try

=SUBTOTAL(101,A2:A100)
Where A2 -A100 is the unfiltered range

Mike
 
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 value only for the filtered area.. 4
Excel Issue with "Average" showing in Status Bar 2
Averaging Data 2
averaging with a filter 1
how do I average a range which also contains empty cells 2
Average 10
Averaging Data continuously when using Filter function - Need Help 6
Average within quartiles 3

Back
Top