How to find the number of passing students in Excel

Excel often needs to use functions to count the number of passers, how to use functions to count the number of passers? The following is the method of counting the number of passing students in excel** shared by Xuezhi.com for everyone to read and learn.

Excel** method of counting the number of passers:

Step 1: Counting the number of passers in a single subject. For example, to calculate the number of language passers, open the score statistics table, and enter the number of language passers in E1.

Step 2: Click E2, click Fx and paste the countif function to OK.

Step 3 of counting the number of passers: fill in the language score area B2:B51, enter the condition "=60, and confirm.

Step 4: Calculate the result, the number of Chinese passers is 29, and the other two subjects have the same algorithm as the number of passers, which can be copied to the right using the fill handle.

Count the number of passersStep 5: How to count the number of passers in three subjects? Select b1:d1 and click Data --- Filter --- Autofilter.

Count the number of passing peopleStep 6: Click the drop-down triangle of the language, select Custom, the selection condition is greater than or equal to, enter 60, OK, in this way, the language passing will be filtered out, the same setting mathematics and English, as a result, the rest of the data are all passing in English.

Count the number of passersStep 7: If there are only a few people, you can count them a little, if there are a lot of people, then you can't directly use the count function to calculate, because it will also count the hidden cells.

Step 8: What should I do? Copy part of the data first, paste it into sheet2, and then look at what the number of rows is, the number of fully passing people is what is, and you can see that the number of full passing students is 27.

1. First, enter the score in Excel** and click on the blank cell under the selected pass rate.

2. Enter the calculation formula in the cell: =countif(a2:a6,">60")/count(a2:a6)。

3. After generating the result, enter the formula: =countif(A2:A6,) under the excellent rate">85")/count(a2:a6)。Sold with.

4. The results of passing rate and excellent rate can be generated, and the two calculation results can be adjusted to the percentage display.

5. Enter the formula below the number of passers: =countif(A2:A6,">60")。

6. Click Enter to generate 3 passers, and then enter the formula for calculating the number of outstanding people: =countif(A2:A6,">85")。

7. After the result is generated, you can show the required manifestation of the divine result in the cell.

Firstly, enter the score in the excel sheet, and click to select the blank cell under the pass rate.

2. Enter the calculation formula in the cell: =countif(a2:a6,">=60")/count(a2:a6)。

3. After generating the result, enter the formula: =countif(a2:a6,) under the excellence rate">=85")/count(a2:a6)。

Fourth, generate the results of pass rate and excellent rate, and adjust the two calculation results to the percentage display.

5. Then enter the formula under the number of qualified people: =countif(a2:a6,">=60")。

6. Click the [Enter] button to generate 3 qualified personnel, and enter the calculation formula for excellent personnel: =countif(A2:A6,">=85")。

7. After generating the result, you can display the desired display result in the cell.

1. First, count the number of passers, and enter the calculation formula in the blank cell: =countif(A2:A6,">=60")。

2. Click Enter to generate the calculation result, and you can see that the number of passing students is "3". 3. Then calculate the passing rate, and directly enter the calculation formula: =b2 5*100%.

4. Click Enter to see that the passing rate is "60%", and the specific number of people will be changed according to the actual number of people. 5. Calculate the number of outstanding people, take more than 85 points as an example, and enter the calculation formula: =countif(A2:

a6,">=85")。6. Click Enter to see that there is 1 person who is excellent, and then calculate the excellent rate, enter the formula: =d2 5*100%.

7. All the data content that needs to be calculated can be calculated and displayed in **.

Tools Materials: Computer, Excel.

1. Turn on the computer, open the software, open the document that needs to be modified, and find the number of people who fail in the column to be counted;

2. Then find the cell and enter the formula =countif(a:a,"<60"The first parameter is the statistical range of the formula, and the statistical condition of the second formula parameter, if you want to find the number of people who fail now, the condition is <60, and the statistical result can be obtained after pressing enter;

3. Similarly, if you want to count the number of people with more than 90 points, then the condition parameters are replaced">=90"Yes.

Tools Materials: Computer, Excel.

1. Turn on the computer, open the manuscript banquet software, open the document that needs to be modified, and find the number of people who fail in the column to be counted;

2. Then find the cell and enter the formula =countif(a:a,"<60"The first parameter is the statistical range of the formula, and the statistical condition of the second formula parameter, if you want to find the number of people who fail now, the condition is <60, and the statistical result can be obtained after pressing enter;

3. Similarly, if you want to count the number of people on the key with 90 points, then the conditional parameters are replaced by">=90"Yes.

Enter the results for each subject. After the final exam, the teachers need to count the results of each subject, and then rank the excellent rate, pass rate and ranking.

Determine the row for the number of passers. Because the statistics of each ** are different, choose a suitable position to write a few numbers, so that it will be clearer when calculating, the number of passing people in each subject.

Enter "=countif(b2:b15,">59"uproar" function. There is a function to calculate the number of passers, which is countif, which directly enters the range of cells to be calculated, so that the corresponding number of people can be calculated.

Click to tick. Then you have to click the tick directly, otherwise you can't calculate it in the corresponding cell, and it will also make the whole ** look messy.

Count out the number of people in each subject. Then, in the same way, enter the statistical function, and then calculate the one-to-one correspondence, so that you can quickly get the answer.