1, AVERAGE calculates the average.

The most established usage, which is also the most common usage, is used when all students are not absent from the exam. The formula expression is:

Average value (C 1:C20), as shown in the following figure:

2、AVERADEA？ Calculate non-null average value

When a student is absent from the exam, you can use this function to evaluate. As long as the cell is not empty, the students who are absent from the exam will be counted, and the data area should be selected from the next cell of mathematics, otherwise the mathematics will be counted, leading to calculation errors. The formula expression is:

Abela Asia (C2:C20), as shown in the following figure:

3. average IF? Meet the single condition, on average.

When managing multiple classes, you can use this function when you need to count the mathematical average of each class separately, that is, when you want to find the average that meets certain conditions. For example, if you manage three classes, you need to find the mathematical average of each class separately. The formula expression is:

Average if ($ a $ 1: $ a $20, E3, $ c $ 1: $ c $20), using absolute reference, is to facilitate the drop-down filling formula. As shown in the figure below:

4. Average life expectancy? Meet multiple conditions and average.

When multiple conditions need to be met at the same time, this function can be used to find the average of mathematics scores. For example, to find the average math score of a class of girls, the formula is: Average IFS (D 1: D20, A 1: A20, F3, C 1: C20, G3).

As shown in the figure below: