How to find the average using sumif function

First we use a score table data to illustrate the use of the sumif function in Excel data statistics. The specific method is introduced below:

According to the data table, we first average the average score of each student. Here's a quick way. Select the cell, click the small inverted triangle under [Function Menu]-[Formula]-[AutoSum], and select [Average].

Then it will be quickly inserted into an average function. We can confirm the data area. If there is no problem, just click [OK] and you will get Get the average score. Subsequently, as long as you select according to this formula, you can quickly fill in and find the average score of all students.

##Related recommendations: "

excel basic tutorial"

Then we started to find each Statistics of individual fractional segments. First, fill column W with a number 1 in each row, which means the number of people in a row is 1. This is very important. First fill in a column of data 1.

Calculate [the number of people whose average score is greater than 80 points]. Just enter the following formula in cell U13 [=SUMIF(V2:V9,">80",W2:W9)].

Then press the [Enter] key to get the corresponding result.

Calculate [the number of people with a score greater than 80 in Subject A]. Just enter the following formula in cell U14 [=SUMIF(R2:R9,">80",W2:W9)].

Then press the [Enter] key to get the corresponding result.

Calculate [the number of people with a score greater than 80 in subject C]. Just enter the following formula in cell U15 [=SUMIF(T2:T9,">80",W2:W9)].

Then press the [Enter] key to get the corresponding result.

Calculate [the number of people with a score greater than 90 in Subject D]. Just enter the following formula in cell U16 [=SUMIF(U2:U9,">90",W2:W9)].

Then press the [Enter] key to get the corresponding result.

The above is the detailed content of How to find the average using sumif function. For more information, please follow other related articles on the PHP Chinese website!