How to use the AVERAGEIF function in Excel
How to use the AVERAGEIF function in Excel
Learn how to use the AVERAGEIF function in Microsoft Excel. This tutorial demonstrates how to use Excel AVERAGEIF with an easy to follow example and takes you step-by-step through the different options when entering your formula.
AVERAGEIF Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0 -> AVERAGEIF is one of the
statistical functions in Excel
4.28 -> If you have a range of values
6.5 -> and you want to average together only
those numbers that meet a specific criteria
11.08 -> AVERAGEIF is a great function to use
13.92 -> To illustrate how the AVERAGEIF function works,
let's look at an example
18.54 -> Here we have a table of data that
consists of Year and Value columns
23.64 -> We will use the AVERAGEIF function
to average only those values
27.38 -> where the corresponding year
is equal to 2012
31.04 -> To get started, let's begin by
entering the AVERAGEIF command
35.36 -> As you can see, the AVERAGEIF function
takes three parameters
40.02 -> The first parameter we will enter is the range of cells
that you want to apply the criteria against
46.66 -> In our example, we will enter the range A2:A7
51.26 -> This is the range of cells that will be tested
to determine if they meet the criteria
57.05 -> The second parameter we will need to enter is
the criteria that will be applied against the range A2:A7
64.16 -> This criteria can be either a value or
the reference to a cell that contains a value
70.46 -> In our example, we will enter the value 2012
74.74 -> The AVERAGEIF function will test each value in
the range A2:A7 to see if it matches the year 2012
82.48 -> The third parameter is optional
85.1 -> It is the range of values to average
87.82 -> If we don't provide this third parameter,
the AVERAGEIF function will automatically
92.72 -> use the value that we provided from the
first parameter as the range of cells to average
97.68 -> Meaning, it would try to average
the values in cells A2:A7
102.96 -> Since we want to average the values in column B and
not column A, we will enter a range of B2:B7
110.9 -> This means that every value in
the range A2:A7 that matches the year 2012
117.58 -> the corresponding value in B2:B7
will be averaged
121.8 -> Now that we have entered all of the parameters,
let's complete the command to look at our result
127.48 -> You should see the value 8.2 appear
130.76 -> This value is calculated by
averaging the value 6 and 10.4
136.1 -> The other values in the table will be ignored
since their year value is not equal to 2012
142.68 -> This covers a simple example of how
to use Excel's AVERAGEIF function
147.7 -> If you would like to see more examples
150 -> or would like to download
the sample data we used for this tutorial
153.42 -> please visit our website
at TechOnTheNet.com
156.88 -> If you found our tutorial helpful,
please leave a like on this video
161.24 -> and don't forget to subscribe to our YouTube channel
for more great Excel tutorials
Source: https://www.youtube.com/watch?v=39qBSi-H_Vc