Excel COUNT Function and Formula with Examples


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

  • 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.

Excel COUNT Function Examples

Suppose you have the following list of items that consist of item codeitem namequantityunit price, and unit cost.

 ABCDE
1Item CodeItem NameQtyUnit Cost ($)Unit Price ($)
2Item01 Desktop PC 122200.00225.00
3Item02 Desktop PC 220150.00750.00
4Item03 Desktop PC 325210.00235.00
5Item04  Desktop PC 427780.00785.00
6Item05  Desktop PC 5301040.001010.00
7Item06  Desktop PC 638230.00255.00
8Item07 Desktop PC 741274.00290.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 functionCOUNT 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.

Leave a Reply

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