| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add rows to top of list instead of bottom | Excel Worksheet Functions | |||
| Averaging values from a list, based on user input | Excel Worksheet Functions | |||
| How to remove the top & bottom 10% from a list? | Excel Discussion (Misc queries) | |||
| How to remove the top & bottom 10% from a list? | Excel Worksheet Functions | |||
| Dynamic named list includes blank cell at bottom | Excel Discussion (Misc queries) | |||
Linear Mode
