How to Count Names in Excel

To count names in Excel, you can use the COUNTIF function, which counts the number of cells within a range that meet specific criteria. In this case, the criteria will be the name you want to count.

Here's a step-by-step guide on how to count names in Excel:

1. Open your Excel workbook and navigate to the worksheet containing the names you want to count.
2. Click on an empty cell where you want the count to be displayed.
3. Enter the following formula in the cell:

   =COUNTIF(range, "name")

   Replace range with the range of cells containing the names and replace name with the name you want to count. For example, if the names are in cells A1:A10 and you want to count the instances of the name "John", the formula would be:

   =COUNTIF(A1:A10, "John")

4. Press Enter. The cell will now display the count of the specified name within the given range.

Example

Let's say we have the following list of names in cells A1:A7:

A
1 John
2 Jane
3 John
4 Sarah
5 John
6 Jane
7 Sarah

To count the occurrences of the name "John", follow these steps:

1. Click on an empty cell, such as B1.
2. Enter the following formula in the cell:

   =COUNTIF(A1:A7, "John")

3. Press Enter.

The cell B1 will now display "3", as there are three occurrences of the name "John" in the range A1:A7.