Excel 2007 AVERAGEIF
Wednesday May 13, 2009
One of Excel's Something - If functions is the AVERAGE IF function.
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The AVERAGE function is used to find the average value in a range of data while the IF function allows you to have different result occur depending on whether a specific condition is met or not.
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
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The AVERAGE function is used to find the average value in a range of data while the IF function allows you to have different result occur depending on whether a specific condition is met or not.
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
No comments yet. Leave a Comment