How to take an average in an Excel document? – The easiest way

Microsoft Excel will always be the best choice for spreadsheets to make tables, records, tables, and lists that you can use to organize data, calculate accounts, and more. Excel can be downloaded from its official page.

Today we’ll show you one of the program’s basic and most useful formulas, which you can use to average a series of data, taking certain parameters into account when applicable. Stay and learn how to do it.

What is the way to get the average value of an Excel file?

As we all know, the average is the result of adding a series of data, and then Divide by the total amount What about them? While it’s not a very complicated math operation, the truth is that it can get tedious when we have a large registry, but with Microsoft Excel, it’s a lot easier.

If you want to get grade point average

The first method is what we consider the «manual method», assuming you have a list of students, next to their grades of assignments and exams they have taken. If all activities have the same weight, The average can be easily calculated:

1. Hover over any cell you want and type an equals sign «=» to begin.
2. Then open the brackets and select the first commented cell, write the plus sign «+», select the second cell of the second data, «+» and so on, and when you’re done, close the brackets.
3. Then write the division sign «/» and enter the number of data to divide. Finally, hit «Enter» and you’ll get the average of your selections.

You can also delete rows and columns from Excel if you have information you no longer need Advanced in spreadsheets. Next, we have a more automated method using a typical program formula, in this case =AVERAGE.

1. Imagine the same situation as above and hover over any empty cell, but now type =AVERAGE and open the brackets.
2. Then click on the first cell and press the button without releasing it, drag all the data you want to average, and release the click.
3. Close the bracket and press «Enter». This will calculate the average of the selected cells instead of typing them individually.

‘AVERAGE.IF’ function

It’s a variant of the previous formula, except it’s used to consider a criterion, for example, continuing the previous student’s situation, you want get a grade point average But only for girls. To do this, use =AVERAGE.IF and write in it the range of the range, standard and average, just in that order.

To use it, it is necessary that in the list, all students identify whether it is female or male, in addition to that, you must write in another cell the criteria you will use, in this case «female» .

1. In an empty cell, type the formula =AVERAGEIF and open the brackets.
2. The first data you provide is the standard range, i.e. select all cells with the student’s gender qualifier.
3. You write a semicolon, then you have to select the criterion itself, in this case, select the cell where you wrote this criterion, eg «female».
4. Again, semicolons, it’s time to select all the students’ notes normally.
5. Finally, we close the brackets and hit «Enter» and we’ll get the average, but only for girls. When you have all the calculations and necessary data, you can print tables and spreadsheets in Excel for emergencies.

Using the «AVERAGE.IF.SET» function

Here is another variant, in this case several criteria are considered instead of one.It’s a list of students again, but there is one more category, saying that all students on the lista is divided into three distinct parts «A», «B» and «C»; now you want to know the average of girls, but from the «B» section.

The formula to be written is =AVERAGE.IF.SET The input data is the average range, the range of Criterion 1 and Criterion 1, the range of Criterion 2 and Criterion 2, etc. As in the previous case, in addition to determining the gender of each student, each student must have a section to which they belong, and in two separate boxes, there are Criterion 1 (female in this case) and Criterion 2(B).

1. In any cell, type the formula =AVERAGE.IF.SET and open the brackets.
2. The first data is the range you want to average, then select the cells with grades.
3. Then select the range for Criterion 1, the eligible gender of all students.
4. Select the cell where the first criterion (female) is found.
5. Now is the time to repeat steps 3 and 4, but with reference to the conditions of the sections they belong to.
6. Close the bracket and press «Enter».

What if I have multiple averages in Excel?

There are other formulas that organize the data better than hiding the columns for min, max, and mode in the spreadsheet. The organization will be able to serve you in a better way to order the average data of your registry.

Find maximum, minimum and mode

To use them, write =MAX, =MIN, or =MODE, as appropriate, in a separate cell, and open in parentheses, Select data range, close the bracket and press Enter. The max value will give you the highest value, the min value will give you the lowest value, and the pattern will give you the value with the most occurrences.