View Single Post
  #1  
Old April 16th, 2010, 08:18 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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