If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
Display Modes | |
|
|