Microsoft Excel Functions Practice Count and Count if

 Microsoft Excel Functions

COUNT in Excel?

COUNT(value1,[value2],…) The parameters of the COUNT function include comma-separated values. This function returns the total count of numeric values specified. Usage:

COUNT(range) 

This function is used to count the number of cells in a specified range. It can be used to quantify data.

What Does the Function COUNTA Do in Excel?

This function counts cells with data, i.e., non-empty values within a range. The syntax is as follows:

=COUNTA(value1,[value2],…)

The values can be any range too. For example A1:A10

Usage:

How Do You Use COUNTBLANK?

As the name implies, COUNTBLANK is a simple function that counts the number of blank or empty cells. The syntax is as follows:

=COUNTBLANK(range)

The COUNTBLANK function works on a specified range as a parameter.

Usage:

How Do You Use COUNTIF?

The COUNTIF function counts cells that match specific criteria. The syntax is as follows:

 =COUNTIF(range,criteria) 

The two arguments here are:

Range- which can be specified as a range of cells in Excel. For example B1: B6

Criteria- a condition on the function. For example: “>50”, A1

This function works on the specified range, counting the cells that match the criteria or condition. 

Usage:

COUNTIF can be used to match the criterion with a string.

For example: 

COUNTIF can be used to count cells with the help of logical operators: Greater than, equal to or less than.

For example: 

How Do You Use COUNTIFS?

This function is a plural counterpart of the COUNTIF function. It calculates the count of cells upon meeting multiple criteria.

The syntax is as follows:

=COUNTIFS(range1, criteria1,[range2, criteria2]…)

Here, range1 maps to the criteria1, range2 maps to criteria2, and so on.

The range1 and criteria1 are required arguments while the rest in square brackets are optional.

Range1 will be the range of cells to which the first condition (criteria1) will be applied.

Criteria1 defines the condition for the function that will work on Range1. The criteria can be any number, string, expression, or it can also be a cell reference. For example, “>=20”, ”China” or A1.

Similarly, [range2, criteria2] defines another set of range and its respective criteria to be met. They follow an ‘AND’ logic.

Multiple range-criteria sets can be added, and they must be comma-separated.

We will demonstrate the usage as follows.