1. Computing
Ted French

Excel AVERAGEIF Function

By April 22, 2012

Follow me on:

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 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
April 25, 2012 at 4:25 pm
(1) steve sidhu says:

How do you use the Averageif formual if the data you want to use is not on the same row or column? example: data is coming from different rows or sheets. I tried: =AVERAGEIF((D28:F28,G29:H29),”>0″,(D28:F28,G29:H29))

with the result going into K30, but it doesn’t work. If i remove the second set of values it works fine. =AVERAGEIF(D28:F28,”>0″,D28:F28)

Same issue if I use multiple sheets.

I could really use your help.

Thanks in advance

Steve Sidhu

Leave a Comment

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

©2014 About.com. All rights reserved.