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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.