Count, Countif, CountA, CountBlank Function in Excel

COUNT Function :

It is used to count the number of cells that contain numbers in a specified range of cells.

Syntax :

=COUNT(value1,value2,...)

Value1, Value2 are the range in which you want to count.
For example:-

COUNTA Function :

It is used to count number of non-blank cells in a specified range of cells.

Syntax :

=COUNTA(value1,value2)

Value1, Value2 are the range in which you want to count.
For Example:-

COUNTIF Function:

It is used to count the number of cells based on a specified condition.

Syntax:

=COUNTIF(range,criteria)

• range : the range in which you want to count.
• criteria : the condition based on which you want to count.
  For Example:-
  

COUNTIFS Function :

It is used to count the number of cells based on multiple conditions.

Syntax :

=COUNTIFS(criteria_range1,critera1,criteria_range2,criteria2)

• criteria_range1 : the range in which you specify the first condition.
• criteria1 : the first condition based on which you want to count.
  For Example:
  

COUNTBLANK Function :

It is used to count the number of blank cells in a specified range of cells.

Syntax :

=COUNTBLANK(Value1,Value2)

Value1, Value2 are range in which you want to count.
For Example:-