# Excel Count Functions

excel count functions COUNT, COUNTA, COUNTBLANK, COUNTIF FUNCTION, Excel Count Functions Examples

## Count Function

Count Function :- COUNT Function in Excel is a numeric function that count the number of cells which contains only numeric Value and uses the format Up to 255 additional items. For example if we need to count record from a range or cells which contains number and alpha values.

=COUNT(A2:A13)

RESULT = 5.

Why do we use:- when we want to count record from a range or cells which contains number and alpha values.

Syntax : COUNT (Value1, Value2…Value3….,)

Arguments:-

Value1 (required) – cell reference, or range within which you want to count the numbers.

Value2 (optional). – Optional but we can use Up to 255 additional items, cell references, or ranges

Count in range.

In this picture we tried to show you we have Alpha value, Blank Cells and Numeric value in selected range and count function returns only numeric count “5”.

Count in multiple arguments.

In this picture we tried to show you we have Alpha value, Blank Cells and Numeric value in selected range and count function returns only numeric count “3”.

## COUNTA Function

COUNTA function in excel is a alpha numerical function that counts the record contains in cells that have alpha numeric value for example if we count records from a range or cells that contain numbers and other information except blank cell.

=COUNTA (A2:A14)

RESULT = 11

Why do we use:- when we want to count record from a range or cells which contains number and alpha values.

Syntax COUNT (Value1, Value2…Value3….,)

Arguments:-

Value1 (required) – cell reference, or range within which you want to count alpha numeric record

Value2 (optional) – Optional but we can use Up to 255 additional items, cell references, ranges or alpha numeric record

Count in range.

In this picture we tried to show you we have Alpha value, Blank Cells and Numeric value in selected range and count function returns only numeric or alpha count “11.

Count in multiple arguments.

In this picture we tried to show you we have Alpha value, Blank Cells and Numeric value in selected range and count function returns only numeric or alpha count “6”.

## COUNTBLANK Function

Count blank function in excel does not count alpha numerical errors, etc. are not counted by this function, it only count blank records.

=COUNTBLANK (A2:A14)

RESULT = 2

Why do we use:-The range from which you want to count the blank cells.

Syntax COUNT (Value1, Value2…Value3….,)

Arguments:-

Value1 (required) – cell reference, or range within which you want to count alpha numeric error etc. not record which blanks are to be counted

Count in range.

In this picture we tried to show you we have Alpha value, Blank Cells and Numeric value in selected range and count function returns count of only blank cell “2”.

## COUNTIF FUNCTION

Countif Function is used to count the records from selected range according to defined criteria from selected range, Countif function can count text, numeric value and date. Countif function supports the logical expression < (less than), >(Greater than), <>(Not Equals to), =(Equals to) and it also supports the wildcards (*) and partial matching. In this picture we tried to show you we have Alpha Value, Blank Cells, and Numeric Value in selected range and countif function returns count of record which have value greater than “1”.