Hi Bernard,

Thanks for helping me explain better....The cells I am averaging are the
number of days and are in number format with 2 decimals, so it's the numbers
in column G that I want to average but I want it to not count any numbers
greater than 10. I am using Excel 2003.

Linda

"Bernard Liengme" wrote in message
...
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