EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Count Names in Excel
 

Count Names in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated June 9, 2023

Count Names in Excel

 

 

Overview of Count Names in Excel

Excel has multiple functions, and one of its practical uses is counting names from a large dataset. However, when dealing with a lengthy list of data, counting names can be time-consuming. Fortunately, Excel offers COUNT and other related functions to count names in Excel and simplify the overall process.

Count names in Excel means using functions that help you count how many times a name appears in a table or range of cells.

The article will include information about the following functions. Along with each function, we have provided clear examples to help understand how they work.

  • COUNT
  • COUNTIF
  • COUNTA
  • COUNTIFS
  • LEN
  • COUNTBLANK

How to Count Names in Excel?

We will learn to count names in Excel by starting with basic examples and gradually moving on to more complex ones. We have also provided an Excel template with all the solved examples for reference.

You can download this Count Names Excel Template here – Count Names Excel Template

Example #1 Counting Names with Age Data

The table below contains a list of names and their corresponding age. However, it contains errors and blank cells too. Therefore, we will use the COUNT function to determine the total number of cells that contain only age.

Solution:
Step 1: Open MS Excel and create a data table with Name and Age columns (Columns A and B, respectively
Count Names in Excel example 1.1

Step 2: Create a new column heading “COUNT Name” in cell D2.
Count Names in Excel example 1.2

Step 3: In cell D3, enter the formula =COUNT(B2:B10).
The formula will count the number of cells containing only numbers and ignore texts and other values.
Count Names in Excel example 1.4

Step 4: Press Enter key to get the result.
Count Names in Excel example 1.5

Result: The data has six integer values; therefore, the formula gives the output of 6.

Example #2 Counting Names Having a Common String

The below table lists some names with their age. We want to find the count of names containing the suffix “Jr.” using the COUNTIF function.

Count Names in Excel example 2.1

Solution:
Step 1: Create a new column heading “COUNT Name” in cell D1.
Count Names in Excel example 2.2

Step 2: In cell D2 start typing the formula =COUNTIF(A2:A10)

Note: This is not the complete formula.

Count Names in Excel example 2.4

Step 3: Now, provide the criteria by writing =COUNTIF(A2: A10,”*Jr.”) in cell D2.
Count Names in Excel example 2.5

Step 4: Press Enter key to see the result
Count Names in Excel example 2.6

Result: The data consists of three names with the suffix “Jr.” therefore, the formula gives the output of 3.

Example #3 Counting the Number of Letters Ending with a Specific String

A user needs to count the number of names containing the string “ry” and having a length of 5 letters. We can achieve this using the COUNTIF function. Let’s explore how.

Solution:
Step 1: Open MS Excel and create a data table containing three columns (Columns A, B, and C) for Name, Height, and Age.

Count Names in Excel example 3.1

Step 2: Create a new “Count Name” column heading in cell E1.
Count Names in Excel example 3.2

Step 3: In cell E2, begin writing the formula with =COUNTIF(
RY string example 3.3

Step 4: Provide the range A2 to A10 by writing =COUNTIF (A2: A10,
RY string example 3.4

Step 5: To narrow down the search and only count names with 5 letters that contain the string “ry,” enter the formula =COUNTIF(A2:A10, “???ry”) in cell E2.
RY string example 3.5

Step 6: Press Enter key to see the result.
RY string example 3.6

Result: Two names have “ry” in them; therefore, the formula gives the output of 2.

Example #4 Using COUNTA Function

The following table contains data on 10 equipment pieces tested to check their output. We want to count the number of outcomes using the COUNTA function in Excel.
Example 4

Solution:
Step 1: In an empty cell (Cell F6), enter the formula =COUNTA(C6:C15)
The formula counts the total number of non-empty cells from C6 to C15.
Example 4 Step 1

Step 2: Press Enter to get the result (see the image below)
Example 4 Step 2

Result: The selected range consists of eight non-empty cells; therefore, the formula produces an output of 8.

Example #5 Using the COUNTIF Function

The table below has information about students, including their roll numbers and marks. We want to determine how many students scored above 60 using the COUNTIF function.
Example 5

Solution:
Step 1: In an empty cell (Cell F6), enter the formula =COUNTIF(C6:C14,”>60″)
The formula counts the number of cells with an integer value greater than 60.
Example 5 Step 1

Step 2: Press Enter key to obtain the result.
Example 5 Step 2

Result: Five students scored more than 60. Therefore, the formula yields the result of 5.

Example #6 Using COUNTIFS Function

The table below lists people with their names, gender, and city. We want to count the number of males belonging to Mexico using the COUNTIFS function in Excel.
Example 6

Solution:
Step 1: In an empty cell (Cell F6), enter the formula: =COUNTIFS(B6:B12,”Male”,C6:C12,”Mexico”)
The formula first locates “Male” in the range B6:B12, then finds “Mexico” in the corresponding rows in the range C6:C12, and counts the number of rows.
Example 6 Step 1

Step 2: Press Enter to see the result.
Example 6 Step 2

Result: Two rows contain “Male” belonging to the “Mexico” city. Therefore, the formula produces the output of 2.

Example #7 Using LEN Function

The table below demonstrates how to use the LEN function in Excel to determine the character count in various types of strings. It displays each string in the list, the formula used to calculate its length using the LEN function, the count of characters in the string, and a brief description.

For instance, the formula =LEN(A6) shows a count of 4 for the first string, “7234”, which has 4 characters.
Example 7

Example #8 Using the COUNTBLANK Function

The table contains customer information, including their Invoice numbers and the total amount they have to pay. However, some cells in the table are empty, and we need to determine the number of empty(blank) cells using the COUNTBLANK function in Excel.
Example 8

Solution:
Step 1: In an empty cell (Cell E6), enter the formula =COUNTBLANK(B6:C11)
The formula counts the number of blank cells within the range B6:C11.
Example 8 Step 1

Step 2: Hit the Enter key to check the result
Example 8-2

Result: The data set has three empty cells; therefore, the formula yields the result of 3.

Things to Remember About Count Names in Excel

  • The COUNT function does not count cells containing text, logical values (TRUE or FALSE), error values (such as #VALUE! or #N/A), or blank cells. For example, if you use =COUNT(A1:A4) and one of the cells has the word “kiwi” in it, the formula won’t count it.
  • In COUNTIF criteria, the asterisk (*) is a wildcard character that matches any set of characters. For instance, the formula =COUNTIF(A1:A10,”*gmail.com”) will count all the email addresses from the range A1:A10 that ends with @gmail.com.
  • If you use a question mark (?) in the criteria for COUNTIF, it will match any character. For example, =COUNTIF(A1:A4, “kiw?”) will count cells that have “kiwi” or “kiwis” in them but not “kiwie” or “kiwifruit“.
  • You can use the less than (<), greater than (>), or equal to (=) operators in COUNTIF to combine criteria. For example, =COUNTIF(A1:A4,” >=10″,” <20″) will count cells that have a value between 10 and 20.

Recommended Articles

The above article is a guide to Count Names in Excel. Here, we discuss how to Count Names in Excel using functions like COUNT, COUNTIF, COUNTA, LEN, and more. You may also look at the following articles to learn more –

  1. Excel Date Format
  2. Text to Columns in Excel
  3. LOOKUP in Excel
  4. VLOOKUP in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Count Names Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Count Names Excel Template

EDUCBA

डाउनलोड Count Names Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW