How to count the number of times a name appears in Excel?

Method: First open the excel table; then click on the cell next to the data and enter "=countif (select area, "name")"; then press the Enter key to get the number of times the name appears.

Method:

1. Open the Excel2007 document and create a new Excel table

2. Open the new Excel table and add the content

3. You can see the content range of the table we created through the picture It is within A1:B16

4. Directly write the formula =COUNTIF(A1:B16,"*Beijing*") at C1!

5. When the formula function is written to C1, the result will be displayed as shown in the figure:

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to count the number of times a name appears in Excel?. For more information, please follow other related articles on the PHP Chinese website!