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