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