# Excel COUNT Function and Formula with Examples

## Learn How to Use the COUNT() Function in Excel

In this tutorial, you'll learn how to use the COUNT function and formula in Excel.

COUNT is a function to count the number of cells containing numbers as well as counts numbers within a list of arguments.

COUNT ignores empty cells and cells that contain text value and can not count with a specified condition.

### COUNT() Syntax

The syntax of the COUNT function is as follows:

=COUNT(value1, [value2], [value3], ...)

### Arguments

• Value1: The first item, a range of cells, or cell reference that you want to count numbers.
• Value2: Optional. The second item, a range of cells, or cell reference that you want to count numbers.
• Value3: Optional. The third item, a range of cells, or cell reference that you want to count numbers.

### Remarks

• You can specify up to 255 arguments.
• COUNT does not count any cell that contains text value.

### COUNT() Function Examples

Suppose you have the demo list of items that consist of item codeitem namequantityunit price, and unit cost, as shown below.

#### Example 1: Counting the number of cells in a single range

Let's say you want to count the number of cells containing numbers in cells C2 through C8.

The COUNT() formula is as follows:

=COUNT(C2:C8)

The formula returns 7.

#### Example 2: Counting the number of cells in multiple ranges

You can use COUNT() to count the number of cells in multiple ranges, as the following formula shows:

=COUNT(C2:C8, D3:D5, E4:E6)

#### Example 3: COUNT() ignores blank cells and cells containing text

COUNT() doesn't count blank cells and cells that contain text value.

Here is an example:

=COUNT(A2:E2)

The formula returns 3 because cells A2 and B2 in the range are the text value.

#### Example 4: COUNTBLANK

To count the number of blank cells, use the following syntax:

=COUNTBLANK(range)

The range argument is the range of cells that you want to count.

Here is an example:

=COUNTBLANK(A2:E8)

The formula returns 0 because there are no blank cells in the range A2: E8.

#### Example 4: COUNTA

You can count the number of cells containing any types of information by using the following syntax:

=COUNTA(value1, [value2], [value3], ...)

The following example shows how to use COUNTA():

=COUNTA(A2:E2, A4:E4, C5:E8)

In this tutorial, you've learned how to use the COUNT function and formula in Excel.

COUNT() is a function to count the number of cells containing numbers in a range of cells.

COUNT() ignores count blank cells and cells containing text value.

You can count the number of cells containing text, error values, and empty text by using the COUNTA() function.

The following are other count functions you can use to count the number of cells:

• COUNTIF(): Count the number of cells with a single criterion
• COUNTIFS(): Count the number of cells with multiple criteria