Do you know how to count people in excel?

php editor Baicao will introduce to you today how to use Excel to count people. In daily work, counting people is a common need, and Excel provides a wealth of functions and tools that can help us complete this task quickly and accurately. Whether it is to count the number of unique people in a certain column of data, or to count people based on conditional filtering, you can easily use the functions of Excel to achieve this. Next, let’s learn how to count people efficiently in Excel!

For veterans who are familiar with Excel, using it to count people is a matter of minutes; but if you are a novice, using ecxel to count people is simply difficult! So how to use it? I compiled a document today, I hope it can help you! Let’s take a look together!

Method 1:

[Use functions to count people] (as shown in the picture)

We are in the bottom unit cell Enter [=COUNT(B2:B6)]; then, press [Enter] to get the number of people.

Method 2:

[Use the status bar to count people] (as shown in the picture).

1. We click the [right button] of the mouse on the Excel status bar, and then check the [Count] button.

#2. Next, we select the [cell area] where we want to calculate the number of people; in this way, we can see the calculation results in the status bar.

Method 3:

You can use the [Ctrl key] to count the number of discontinuous cells to calculate the number of people. All we have to do is hold down the [Ctrl key], and then click on the cell to be calculated.

The three methods shared above are all methods for counting people in Excel; and they are not too difficult, and can be easily completed with simple operations. . Okay, our class today is coming to an end. See you next time!

The above is the detailed content of Do you know how to count people in excel?. For more information, please follow other related articles on the PHP Chinese website!