Countif formula in excel

    how to count names in excel formula
    how to count words in excel formula
    how to count unique names in excel formula
    how to count words in excel using formula
  • How to count names in excel formula
  • How to count text in excel.


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

    Method 1: Count Cells with Exact Name

    =COUNTIF(A2:A11, "Bob Johnson")

    Method 2: Count Cells with Partial Name

    =COUNTIF(A2:A11, "*Johnson*")

    Method 3: Count Cells with One of Several Names

    =COUNTIF(A2:A11, "*Johnson*") + COUNTIF(A2:A11, "*Smith*")

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

    =COUNTIF(A2:A11, "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:

    =COUNTIF(A2:A11, "*Johnson*")

    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

    Copyright ©iceshow.et-school.edu.pl 2025