What is the function to calculate the number of people in excel

#What is the function in excel to calculate the number of people?

The first step is to open excel, select a cell as the result of counting people, and click fx, as shown below:

Recommended: "excel tutorial"

After entering the second step, search to find the counta function. This function counts the number of non-empty cells and can be used to count people, as shown in the figure below ：

In the third step, after entering the counta function, select the statistical data, here is A2:A7, as shown in the following figure:

After clicking OK in the fourth step, you can see that the number of people counted is 6, as shown in the figure below:

We can also take a look at the fifth step count function, this function is used to count cells containing numbers, as shown in the figure below:

The above is the detailed content of What is the function to calculate the number of people in excel. For more information, please follow other related articles on the PHP Chinese website!