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.  

Excel Count Functions
Count Function

=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
COUNT

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

Count in multiple arguments.
Count in multiple arguments.

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
COUNTA Function

=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 range.
count in range.

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

Count in multiple arguments
Count in multiple arguments

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
COUNTBLANK FUNCTION

=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”.

Excel Count Functions
Count in range.

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

Countif Function
Countif Function

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

Syntax COUNTIF (Range,Criteria)

Arguments:-

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

Criteria (Required). – Criteria is the condition which we will define to count record from selected range. Criteria supports the logical expression < (less than), >(Greater than), <>(Not Equals to), =(Equals to) and it also supports the wildcards (*) and partial matching

Hope this article helps you to solve your issue, please connect with us for such articles.

%d bloggers like this: