Home ALL NEWS & INFO DIGITAL SKILLS How to Use the COUNT Function in Microsoft Excel

How to Use the COUNT Function in Microsoft Excel

How To Count Blank - Empty Cells In Microsoft Excel How to Compare Two Lists in Microsoft Excel How to Add Numbers in Microsoft Excel If you need to get the sum of two or more numbers in your spreadsheets, Microsoft Excel has multiple options for addition. We’ll show you the available ways to add in Excel, including doing it without a formula.

How to Use the COUNT Function in Microsoft Excel

Counting how many cells contain numbers is a basic and useful task. With this in mind, Microsoft Excel gives you a handy function to save you from counting cells manually.

The function is COUNT and here’s how to use it.

You may have a column full of both numbers and text where you only want the total count of the cells with numbers.

You might even want this type of count for an entire sheet or ranges of non adjacent cells. All of this can be done with the COUNT function.

What You Can Count With COUNT

The COUNT function counts cells with numbers but also includes dates, currency, percentages, numbers enclosed in quotes, and numbers in a table or pivot table in Excel.

It does not count logical values, text, or errors containing numbers.

There are variations of the COUNT function such as COUNTIF for counting cells with certain criteria and also COUNTBLANK for empty cells. Be sure to check out our how-tos for these variations as well.

Use the COUNT Function in Excel

To get started, open your workbook and head to the sheet you want to use in Excel.

Go to the cell where you want to display the result of the formula.

You can then use the Count Numbers option in the Sum list or enter the formula manually.

To use the Count Numbers option, go to the Home tab. Click the Sum button in the Editing section of the ribbon and select “Count Numbers.”

Count Numbers In The Sum Button

This method works great for basic counts like one cell range. For more complicated situations, you can enter the formula containing the function.

The syntax for the function is COUNT(value1, value2,...) where value1 is required and value2 is optional.To start simple, you can obtain the count for cells with numbers in the range A2 through A11, using the following formula:


You can see here, each cell in our range contains a number. This gives us the total count of 10.


Count For A Single Cell Range

If that same range of cells contains text in five of the 10 cells, the formula’s result is 5.

Count For A Single Cell Range With Text

To obtain the count for non adjacent cell ranges A2 through A6 and B6 through B11, you would use this formula:


Count For Two Cell Ranges

You can include even more cell ranges, if necessary, with the COUNT function.

This formula counts the cells in A2 through A11, C2 through C11, and E2 through E11.


Count For Mutliple Cell Ranges



Please enter your comment!
Please enter your name here

error: Content is protected !!