 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Averaging 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. Apologies you gave the range =SUBTOTAL(101,G11:G94) Mike > 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 > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.