| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Average Function but exclude info
Hi Everyone,
Excel 2003. I have a list of numbers. I use the Insert/Function then drag the cells I want to create my formula for averaging this column. I would like to have another cell with the average of this column but want to exclude any number greater than 10 days. Right now my only option (because of lack of knowldege) is to resort my list and manually exclude anything I see that is greater than 10 days. For this particular sheet my formula is =AVERAGE(Jan!G2:G7). Thanks, Linda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I exclude the HIGH and LOW values in the =AVERAGE function | Excel Worksheet Functions | |||
| Average (exclude 1 min & 1 max Value) | Excel Discussion (Misc queries) | |||
| Pivot Table - How to exclude info without showing? | Excel Worksheet Functions | |||
| Exclude zero values using average function in a pivot table | Excel Discussion (Misc queries) | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
![Linda RQ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
