This article uses the countif function to count the number of items that meet the conditions.
1. Select the cell and click on the edit bar to insert the function symbol
2. Or select the cell and click under [Sum] on the toolbar. [Other functions]
#3. After entering the insert function page, enter: countif in the search function box, select: COUNTIF in the select function list, and click [ OK】
4. Enter the function parameter page and select the area to be judged: C2:C10
5. Enter: >=60 in the conditions, click [OK] below
6. Return to the table and you can see that the number of people who passed the Chinese language has been calculated.
7. Place the mouse on a small square in the lower right corner of the cell, hold down the left mouse button, and drag and copy to the math and English columns. You can get the number of qualified people in these two columns
Recommended tutorial: excel tutorial
The above is the detailed content of Use countif function to count people. For more information, please follow other related articles on the PHP Chinese website!