## How to Use the COUNT Function and Formula in Excel

In this tutorial, you'll learn how to use the **COUNT function** and formula in Excel. The **Excel COUNT **is a function used to count the number of cells containing numbers as well as counts numbers within a list of arguments.

**COUNT** doesn't count empty cells and cells that contain text value, and can not count with a specified condition. The following are other count functions in Excel:

The following are other count functions in Excel:

**COUNTBLANK**: Count the number of blank cells**COUNTIF**: Count the number of cells with a single criterion**COUNTIFS**: Count the number of cells with multiple criteria**COUNTA**: Count the number of cells containing text, error values, and empty text

To count only cells that are not blank, use the **COUNTA** function. And if you want to count the blank cells, use the **COUNTBLANK** function.

To count cells that meet single criteria, use the **COUNTIF** function, and

use the **COUNTIFS** function, if you want to count cells that meet multiple criteria.

### COUNT **Syntax**

The syntax of the **COUNT function** is as follows:

=

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

**Arguments**

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

### Remarks

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

### Excel COUNT Function Examples

Suppose you have the following list of items that consist of **item code**, **item name**, **quantity**, **unit price**, and **unit cost**.

A | B | C | D | E | |

1 | Item Code | Item Name | Qty | Unit Cost ($) | Unit Price ($) |

2 | Item01 | Desktop PC 1 | 22 | 200.00 | 225.00 |

3 | Item02 | Desktop PC 2 | 20 | 150.00 | 750.00 |

4 | Item03 | Desktop PC 3 | 25 | 210.00 | 235.00 |

5 | Item04 | Desktop PC 4 | 27 | 780.00 | 785.00 |

6 | Item05 | Desktop PC 5 | 30 | 1040.00 | 1010.00 |

7 | Item06 | Desktop PC 6 | 38 | 230.00 | 255.00 |

8 | Item07 | Desktop PC 7 | 41 | 274.00 | 290.00 |

#### Example 1: Count 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. You can write the **COUNT formula** as follows:

=

COUNT(C2:C8)

Here, only one argument, which is the range of cells C2:C8, in this formula.

The result of the formula is 7, so there are seven cells in the range C2:C8.

#### Example 2: Count the Number of Cells in Multiple Ranges

The COUNT formula to count the number of cells in multiple ranges will look like this:

=

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

#### Example 3: COUNT Ignores Blank Cells and Cells Containing Text

The **COUNT function** doesn't count blank cells and cells that contain text value.

Now, let's take a look at an example:

=

COUNT(A2:E2)

In the above formula, two cells A2 and B2 contain the text value, so **COUNT** does not count them. The result is 3.

#### Example 4: COUNTBLANK

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

=

COUNTBLANK(range)

Where ** range** is the range of cells that you want to count.

Let's take at an example:

=

COUNTBLANK(A2:E8)

Since no blank cells in the range A2:E8, the above formula return 0.

#### Example 4: COUNTA

To count the number of cells containing any type of information, use the following syntax:

=

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

The following is an example using the **COUNTA** formula:

=

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

In this tutorial, you've learned how to use the **Excel COUNT function**. **COUNT** is a function to count the number of cells containing numbers in a range of cells. It doesn't count blank cells and cells that contain text value. You need to use the COUNTA function if you want to count the number of cells containing text, error values, and empty text, and you can count the number of cells with a condition using the SUMIF function.