average function

[peteb]

i have a collegue who want to calculate the average of a filtered list, as in only calculate the results from the filter not the whole column/row

[lvalnegri]

i have a collegue who want to calculate the average of a filtered list, as in only calculate the results from the filter not the whole column/row

If you are on excel 2007 you can use AVERAGEIF(Range, Criteria, Average_range), where: Range is the group of cells the function is to search; Criteria determines whether the data in a cell is to be averaged or not; Average_range is the data range that is averaged if the first range meets the specified criteria (if this range is omitted, the first range is averaged instead). If your version is prior to 2007 you should use the ratio SUMIF(Range, Criteria, Sum_range)/COUNTIF(Range, Criteria).

[peteb]

thanks i will try that btw working with office 2010