Recently, I covered how to use the SUMIF function in Excel. Related to this is the AVERAGE IF function. AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.

The IF function introduces decision making to your spreadsheets. The AVERAGE function is used to find the average value in a range of data.

AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.

To find out more, read the short article on the Excel 2007 AVERAGEIF function.

Related Articles

• Excel 2007 SUMIF
• Excel 2007 COUNTIF
• Excel 2007 IF Function