Home  >  Article  >  Topics  >  How to use the count function to count the number of employees

How to use the count function to count the number of employees

藏色散人
藏色散人Original
2020-05-17 10:22:4527410browse

How to use the count function to count the number of employees

How to use the count function to count the number of employees?

1. First, open the table we want to operate on in Excel. The editor will take the table shown in the figure below as an example:

Recommendation: "Excel Tutorial

How to use the count function to count the number of employees

2. Next, select cell B11, then click "Formulas" at the top of the page, find and click "Insert" in the menu bar below it function".

How to use the count function to count the number of employees

#3. After opening the Insert Function window, set "Or Select Column" to "Statistics", and then select the "COUNT" function. After selecting, click "OK".

How to use the count function to count the number of employees

4. After opening the function parameter window, select all cells B2-B10, and then click "OK". After that, the number of salespeople with sales will be It is displayed in cell B11, as shown in Figure 2 below:

How to use the count function to count the number of employees

5. Then, select B12 and click "Formula" - "Insert Function". After opening the Insert Function window, first select "Statistics" and then select the "COUNTA" function.

How to use the count function to count the number of employees

6. After opening the function parameter window, select cells A2-A10, and then click "OK". After that, the number of salespeople in this group will be displayed in B12, as shown in Figure 2 below:

How to use the count function to count the number of employees

The above is the detailed content of How to use the count function to count the number of employees. 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
Previous article:How to set axis scaleNext article:How to set axis scale