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).
Bookmarks