The numbers you want to average are in column G
What column has the dates?
Do you want the average on the same sheet (ie the Jan sheet) or else where?
Want version of Excel ?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Linda RQ" wrote in message
...
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