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.
![Excel-Count-Functions Excel Count Functions](http://einfonet.in/wp-content/uploads/2022/04/image.png)
=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”.
![Excel Count Functions 2 COUNT](http://einfonet.in/wp-content/uploads/2022/04/image-1.png)
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”.
![Excel Count Functions 3 Count in multiple arguments.](http://einfonet.in/wp-content/uploads/2022/04/image-2.png)
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.
![Excel Count Functions 4 COUNTA](http://einfonet.in/wp-content/uploads/2022/04/image-3.png)
=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.
![Excel Count Functions 5 count in range.](http://einfonet.in/wp-content/uploads/2022/04/image-4.png)
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”.
![Excel Count Functions 6 Count in multiple arguments](http://einfonet.in/wp-content/uploads/2022/04/image-5.png)
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.
![Excel Count Functions 7 COUNTBLANK](http://einfonet.in/wp-content/uploads/2022/04/image-6.png)
=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 Excel Count Functions](http://einfonet.in/wp-content/uploads/2022/04/image-7.png)
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”.
![Excel Count Functions 8 Countif Function](https://einfonet.in/wp-content/uploads/2022/05/countif.png)
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.