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:
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!