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
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
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