1. Computing
Ted French

Excel AVERAGEIF Function

By January 16, 2013

Follow me on:

AVERAGEIF 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 will give you different results depending on whether or not a specific condition is met.

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 all the details read the step by step tutorial on Excel's AVERAGEIF function .

Related Step by Step Tutorials
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.