Home  >  Article  >  Topics  >  How to count the number of times a name appears in Excel?

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

烟雨青岚
烟雨青岚Original
2020-07-08 14:50:4132011browse

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.

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

Method:

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

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

2. Open the new Excel table and add the content

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

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

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

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

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

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

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn