How To Use "Count" - "CountA" - "CountBlank" - "CountIF"

Use Of "COUNT" - “COUNTA” – “COUNTBLANK” – “COUNTIF” Formulas in MS Excel

Uses and explanation of "COUNT” Formulas

MS Excel formulas: Easiest way to understand Syntax and usage:

A - Syntax: = COUNT(Value1, Value2,….)

Explanation: Function "COUNT” is very useful working over the excel data. The main work of "COUNT” function to contain the numeric values only. Non numeric and blank values do not contain by "COUNT” function. Let suppose we have huge data with a mixture of names, numeric values and some blank cells. But the requirement is to get only numeric values exact count. You can use "COUNT” to get the exact number of numeric values. But always remember the "COUNT” function will provide only count. (Example: Two cells have numeric values like A1: 500 and A2: 300 after using the "COUNT”  function you will get the result : 2. Function "COUNT”  will not add the values only gives you the count. For more clarification go with Example - 1 below.

Example 1 - Count

Now you can see the above example 1 . The count function is counting only numeric values. If any value is numeric but with some special characters, it will not obtained by count function.
=Count(Value1, Value2,Value3,..........)
Value 1, Value 2 : We can select different cell reference one by one.
or
=Count(B5:B12)
B5 : B12 is range of data source by which we can get the result.
My recommendation: Please prepare the same data with your excel file and use the formula in the same format and do the practices to make your doubt clear.


*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

B - Syntax: = COUNTA(Value1, Value2,….)

Explanation:

Function "COUNTA” is an important function of Microsoft Excel. The work of "COUNTA” is to obtain the data except blank values. "COUNTA” function counts numeric, non numeric, logical and error values also and all type of special characters. You can see example 2 how to calculation is running.

Example-2 - CountA

Now you can easily understand the above example 2 . The "COUNTA” function is obtaining or counting all values (Numeric , Non Numeric and special characters ) except blank cells. Only blank cells will not be obtained by "COUNTA” function.
=Count(Value1, Value2,Value3,..........)
Value 1, Value 2 : We can select different cell reference one by one.
or
=Count(B5:B12)
B5 : B12 is range of data source by which we can get the result.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

C - Syntax: = COUNTBLANK(Value1, Value2,….)

Explanation: Function "COUNTBLANK” is useful working over huge data of excel. "COUNTBLANK” is easy to understand and remember. The main work of "COUNTBLANK” function to count only blank cells over your table reference. Example if we have huge data where the blank cells can be interrupt your report. You can use "COUNTBLANK” function to get all blank values. Let suppose we have a table A1 to A10, the table having some blank values, some numeric and some are non numeric. In order to get only Blank values use "COUNTBLANK”  and we can get the result easily.  For more clarification you can see the below example to clear your doubts.


Example - 3 - CountBlank

See the "COUNTBLANK” function example 3 above . The "COUNTBLANK”  function is obtaining or counting only blank cells.
=Count(Value1, Value2,Value3,..........)
Value 1, Value 2 : We can select different cell reference one by one.
or
=Count(B5:B12)
B5 : B12 is range of data source by which we can get the result.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

C - Syntax:  =COUNTIF(RANGE,CRITERIA)

Explanation:
Function "COUNTIF”  is a logical function a little tricky, interesting and very useful. there are some function which are really very useful and we use daily if we handle reporting in excel, one of them is "COUNTIF” . In order to make good understanding of "COUNTIF”  you must understand the logic of this function. In the function of "COUNTIF”  "count" works to count and "if" is a logical function. Without logic this function will not work. "IF" function have to aspects, one work if value is True and second works if value is False. In this function it is must to define both part True and False.
For more information about "IF" Click Here.


=COUNTIF(RANGE,CRITERIA)
Logic :
Range Means we have to select the range by which we want output.
Criteria: The input value. Let suppose we want to know how many days an student is present in class denoted by "P". Please see the below example.




Count If - Fig-1

For more clarification please see the example above.

My recommendation is use the same data and start practices three and four time to make your doubt clear.



Please comment for more excel query or any suggestions.
Thanks for your time...