COUNT

Description

Use this function to count the number of cells that contain numbers. Supported in Chains. Can be used with CHILDREFS.

COUNT is useful for determining the number of numerical entries in a range or array.

COUNT(value_1,[…,value_254])

This function accepts the following arguments:

Name	Required	Description	Valid input
`value_1`	Yes	The first item, cell reference, or range within which you want to count numbers.	A cell reference, a number, or a formula which results in either of these.
`value_n`	No	Additional items, cell references, or ranges within which you want to count numbers.	A cell reference, a number, or a formula which results in either of these.

Use case Formula Explanation and Result

Count the number of cells in a range that contain numbers.

=COUNT(A2:A5)

This formula works in the following manner:

COUNT(: This is the function itself.
A2:A5: This is the range of cells to evaluate. The function counts how many cells within this range contain numeric values.

For this data set this formula returns 1.

Count the number of cells in a range that contain numbers.

=COUNT(B2:B5)

This formula works in the following manner:

COUNT(: This is the function itself.
B2:B5: This is the range of cells to evaluate. The function counts how many cells within this range contain numeric values.

For this data set this formula returns 4.

Count the number of cells in a range that contain numbers.

=COUNT(A2:B5)

This formula works in the following manner:

COUNT(: This is the function itself.
A2:B5: This is the range of cells (including multiple columns) to evaluate. The function counts how many cells within this entire rectangular range contain numeric values.

For this data set this formula returns 5.

COUNT only counts cells that contain numbers, and ignores empty cells, text, errors, and logical (TRUE/FALSE) values.
COUNT can handle up to 255 arguments.
COUNT can count dates and times, as they are numbers.
COUNT can be used with a combination of values and ranges.

Use COUNT to quickly determine the number of numerical entries in a dataset.
Combine COUNT with other functions such as IF and NOT to create more complex counting criteria.
COUNT is useful for validating data, ensuring that expected numerical inputs are present.
To count:
- numbers only, use COUNT
- numbers and text, use COUNTA
- with one condition, use COUNTIF
- with multiple conditions, use COUNTIFS
- empty cells, use COUNTBLANK