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.

 ABCDE
1Item CodeItem NameQtyUnit Cost ($)Unit Price ($)
2Item01Desktop PC 122200.00225.00
3Item02Desktop PC 220150.00750.00
4Item03Desktop PC 325210.00235.00
5Item04Desktop PC 427780.00785.00
6Item05Desktop PC 5301040.001010.00
7Item06Desktop PC 638230.00255.00
8Item07Desktop PC 741274.00290.00

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

Leave a Reply

Your email address will not be published. Required fields are marked *