Like the SUMIF and SUMIFS functions below, there is also an AVERAGEIF and AVERAGEIFS functions in Excel.
AVERAGEIF looks to match a single criterion while AVERAGEIFS can be used to match from two to 127 criteria ranges.
AVERAGEIFS could be used to pick out data for specific years - allowing you, for example, to average only the profits for the years 2007 and 2009 from a worksheet containing data for the years 2006 to 2010.
To find out more, read the step by step tutorial on the Excel AVERAGEIFS Function.
Related Step by Step Tutorials