How to count the number of occurrences of a person's name in excel

Statistical method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=COUNTIFS (data area, cell where the name of the person needs to be counted)" in the cell; finally press the keyboard Just press the "Enter key" on the screen.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

First click to open the excel table. Prepare the Excel table, mainly focusing on the "Name" field and the "Number of Name Appearances" fields:

In this step, enter the function in cell B2: =COUNTIFS:

Select according to the name field area, and then click "," respect cell A2:

## Based on the above step, press the Enter key and finally get this result:

For different people below Zhang San, you can operate according to the above method. The final result is:

Related learning recommendations:

excel tutorial

The above is the detailed content of How to count the number of occurrences of a person's name in excel. For more information, please follow other related articles on the PHP Chinese website!