Home  >  Article  >  Topics  >  Use countif function to count people

Use countif function to count people

王林
王林Original
2019-10-31 09:40:3980167browse

Use countif function to count people

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

Use countif function to count people

2. Or select the cell and click under [Sum] on the toolbar. [Other functions]

Use countif function to count people

#3. After entering the insert function page, enter: countif in the search function box, select: COUNTIF in the select function list, and click [ OK】

Use countif function to count people

4. Enter the function parameter page and select the area to be judged: C2:C10

Use countif function to count people

5. Enter: >=60 in the conditions, click [OK] below

Use countif function to count people

6. Return to the table and you can see that the number of people who passed the Chinese language has been calculated.

Use countif function to count people

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

Use countif function to count people

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn