How to Count Names in Excel

In this tutorial, you will learn how to count names in Excel.

To count the number of cells that match a requirement, such as the number of times a specific city occurs in a client list, use COUNTIF, one of the statistical functions.

Once you are ready, we can start by using real-life scenarios to help you understand how to count names in Excel.

Anatomy of COUNTIF Function

=COUNTIF(range, criteria)

Range: A collection of cells that you want to count. Range may contain references to numbers, arrays, named ranges, or numbers themselves. Values that are blank or text are ignored.

Criteria: A text string, number, expression, or cell reference that specifies which cells will be counted.

Count Names in Excel

Before we begin we will need a group of data to be used to count names in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we will be looking for the total number of donations made by Jamie. To do you we simply use the COUNTIF function to look for Jamie in the range of data and sum up the total number of donations made. We will insert the following formula =COUNTIF(A2:B7,A10).

Step 3

Once we are done, the formula will return 2. This means Jamie made 2 donations.