How to Count Items in Excel: A Comprehensive Guide for Beginners

Counting items in Excel might seem tricky at first, but it’s actually pretty straightforward. You’ll be using some simple formulas to count cells that contain numbers, text, or are just plain empty. This guide will walk you through it step-by-step, ensuring you can count with confidence.

Step-by-step Tutorial on How to Count Items in Excel

In this section, we’ll go over how to count different types of items in Excel using various formulas. These steps will help you count numbers, text, and blank cells.

Step 1: Open Your Excel File

First, open the Excel file where you want to count items.

Having your Excel file open and ready is essential before you begin. Make sure you’ve located the exact range of cells you want to count.

Step 2: Select the Range of Cells

Step 2, select the range of cells you want to count.

Click and drag your mouse over the cells you’re interested in. This will highlight them, making it clear which cells you’re working with.

Step 3: Use the COUNT Function

Step 3, use the COUNT function to count cells with numbers.

In an empty cell, type =COUNT(A1:A10) (replace A1:A10 with your actual range). This formula will count all the cells in that range that have numbers in them.

Step 4: Use the COUNTA Function

Step 4, use the COUNTA function to count cells with any data.

Type =COUNTA(A1:A10) in an empty cell. This counts all the cells in your selected range that are not empty, regardless of data type.

Step 5: Use the COUNTBLANK Function

Step 5, use the COUNTBLANK function to count empty cells.

Type =COUNTBLANK(A1:A10). This function counts all the empty cells within your specified range.

Step 6: Use COUNTIF for Specific Criteria

Step 6, use COUNTIF to count cells that meet a specific condition.

Type =COUNTIF(A1:A10, "criteria"). Replace "criteria" with whatever you’re looking for (e.g., a specific text or number). This helps you count cells that match your specified criteria.

Once you’ve completed these steps, your Excel file will display the counts according to your specified formulas. You’ll know exactly how many cells contain numbers, any data, or are empty.

Tips for Counting Items in Excel

  • Use the COUNT function for numbers only.
  • The COUNTA function is great for counting non-empty cells.
  • COUNTBLANK helps in identifying empty cells quickly.
  • Use COUNTIF for more specific counts based on conditions.
  • Remember to double-check your cell ranges to ensure accurate counts.

Frequently Asked Questions About Counting Items in Excel

What does the COUNT function do?

The COUNT function counts cells containing numbers. It’s handy when you need to tally numerical data.

Can you count text with the COUNT function?

No, the COUNT function only counts cells with numbers. Use COUNTA to count text.

How do you count blank cells in Excel?

Use the COUNTBLANK function. It counts all empty cells within a specified range.

What’s the difference between COUNT and COUNTA?

COUNT only counts cells with numbers, while COUNTA counts all non-empty cells.

Can COUNTIF be used with text?

Yes, COUNTIF can count cells with specific text or numbers based on the criteria you set.


  1. Open your Excel file.
  2. Select the range of cells.
  3. Use the COUNT function.
  4. Use the COUNTA function.
  5. Use the COUNTBLANK function.
  6. Use COUNTIF for specific criteria.


Counting items in Excel doesn’t have to be a complicated process. By using the COUNT, COUNTA, COUNTBLANK, and COUNTIF functions, you can easily tally numbers, text, and empty cells in your spreadsheet. This powerful feature of Excel can help you manage and analyze your data more efficiently. Remember, the key lies in selecting the right function for your specific need. So next time you’re faced with a mountain of data, just remember these steps and tips to make your counting task a breeze. For further reading, you might delve into more advanced Excel functions or explore how to use these counts in data charts and pivot tables. Happy counting!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy