COUNT Function. Number of numbers.(Microsoft Excel)

05/30/2023

Japanese version.

The COUNT function obtains the number of numeric values in a specified cell range.

How it works

=COUNT(value1 to 255)
NameOmissionDescription
value1 to 255Required argument.Cell range in which to count numbers.

Demonstrate

If non-numeric data are mixed in, they are ignored and counted.

Numbers treated as characters are also ignored.

Blanks, Boolean values, and errors are not included in the count.
Unlike the SUM function, the COUNT function does not error if errors are introduced.

If you want to count non-numeric numbers, use the COUNTA function.

The COUNTA function is probably used more often than the COUNT function.

Specify other than cell range.

It is also possible to have a function argument that returns a range of cells as a result. In that case, it will be the number of results of the function.

List of functions that result in a range of cells.

FunctionCategoryDescription
TEXTSPLITTextDivides text into cells based on a specified character.
XLOOKUPLookup & ReferenceGet data matching the search value.
FILTERLookup & ReferenceGet a list of data that matches the condition.
UNIQUELookup & ReferenceDelete duplicate data in a specified cell range.
SEQUENCELookup & ReferenceCreate sequential numbers in multiple cells.
SORTLookup & ReferenceSort a range of cells by a specified column.
SORTBYLookup & ReferenceSort a cell range by specifying multiple reference columns.
DROPLookup & Referenceelete a specified number of rows and columns from a specified cell range.
TAKELookup & ReferenceObtains a specified number of rows and columns from a specified cell range.
TOCOLLookup & ReferenceArranges a specified range of cells in a single column.
TOROWLookup & ReferenceSort a specified range of cells into a single column.
EXPANDLookup & ReferenceExtended specified cell range.
CHOOSEROWSLookup & ReferenceGet the row at the specified position from the specified cell range.
CHOOSECOLSLookup & ReferenceGet the column at the specified position from the specified cell range.
WRAPROWSLookup & ReferenceSort a range of cells in a single column or row by a specified number of rows.
WRAPCOLSLookup & Reference
Sort a range of cells in a column or row by a specified number of columns.
VSTACKLookup & ReferenceMerge multiple cell ranges in row direction.
HSTACKLookup & ReferenceMerge multiple cell ranges in column direction.
TRANSPOSELookup & ReferenceCreate a cell range with the rows and columns of the specified cell range swapped.

The range can also be specified as an array.

=COUNT({10,1,2,5})

Multiple values can also be specified simply by separating them with commas.

=COUNT(10,1,2,5)

Links

Count of multiple values or cell ranges.

FunctionImportanceDescription
COUNTHighCount of multiple values or cell ranges.
COUNTAHighGet the number of non-blanks.
COUNTBLANKMiddleGet the number of blanks.
COUNTIFMiddleGet the number of cells matching the search criteria.
COUNTIFSHighGet the number of rows that match multiple criteria.

Microsoft Excel Functions Statistical