Averaging from a cell to the bottom of the list
 

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.

Averaging from a cell to the bottom of the list
 

Apologies you gave the range

=SUBTOTAL(101,G11:G94)

Mike

"AAS" wrote:

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.

Averaging from a cell to the bottom of the list
 

Try

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

Mike

"AAS" wrote:

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.