average function

peteb

New member
Joined
Jan 31, 2012
Messages
5
Reaction score
0
Points
0
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

New member
Joined
Jan 31, 2012
Messages
11
Reaction score
0
Points
0
Location
London
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

New member
Joined
Jan 31, 2012
Messages
5
Reaction score
0
Points
0
thanks i will try that btw working with office 2010
 
Top