excel count functions COUNT, COUNTA, COUNTBLANK, COUNTIF FUNCTION, Excel Count Functions Examples
Table of Contents
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”.
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.