Average Function but exclude info
Hi Linda,
Use this formula beside g2:g7 (Column H): =IF($G210,"LESS10","10")
This is to tag your values if it is less 10 or more than 10.
on another column or whatever cell you want to place your average value less
the numbers greater than 10 use this formula:
=SUMIF(G2:G8,"LESS10",F2:F8)/COUNTIF(G2:G8,"LESS10")
"Linda RQ" wrote:
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
.
|