Countif formula in excel

You can use the following methods to count names in Excel:

Method 1: Count Cells with Exact Name

Method 2: Count Cells with Partial Name

Method 3: Count Cells with One of Several Names

The following examples show how to use each method with the following dataset in Excel:

Example 1: Count Cells with Exact Name

We can use the following formula to count the number of cells in column A that contain the exact name “Bob Johnson”:

The following screenshot shows how to use this formula in practice:

We can see that there are 2 cells that contain “Bob Johnson” as the exact name.

Example 2: Count Cells with Partial Name

We can use the following formula to count the number of cells in column A that contain “Johnson” anywhere in the name:

The following screenshot shows how to use this formula in practice:

We can see that there are 4 cells t

how to count words in excel cell formula

how to count duplicate names in excel using formula