*80*

# How to use COUNT, COUNTIF, and COUNTIFS Function?

## Excel COUNT

The COUNT function returns the absolute number of cells that include numbers. This count contains both Numbers and Dates.

### Syntax

Where the parameters, value1, [value2], etc. can be any values or authority to cell ranges.

**Example 1:** The following illustration returns the number of integer values in a given range.

**Example 2:** The following illustration count integer Values in the range A1: A4 and B1:B2.

## EXCEL COUNTIF

**Excel COUNTIF function** is utilized for counting cells inside a selected range that meet a specific rule, or condition.

For example, we can write a COUNTIF equation to discover out how many cells in our worksheet include a number higher than or less than the number we consider. Another common use of COUNTIF in Excel is for counting cells with a particular word or beginning with a specific letter(s).

### Syntax

The syntax for a COUNTIF function in Microsoft Excel is:

Where

**range:** The range of cells that is examined against the given criteria.

**Criteria:** The condition which needs to be examined against each cell in the range.

#### Note: If our criteria is a text string or a statement, then it must be enclosed in the double-quotes.

**Example:** The COUNTIF function following counts the number of cells that are higher than or equivalent to 5.

## Excel COUNTIFS

The Excel COUNTIFS function takes in at least one cell range and returns the total counts if criteria are fulfilled.

### Syntax

Where **criteria_range1:** Arrays of values (or ranges of cells including values) to be examined against the particular criteria1, criteria2 … (The provided criteria_range arrays must all have the similar length).

**criteria1:** The conditions to be examined against the values in the criteria_range1, [criteria_range2],….

**Example 1:** The following example displays the use of the COUNTIFS function.

In this example, we want to count the number of persons who fulfilled these two criteria.

- A person should be female.
- A grade should be <=D, which is between A to C.

**Example 2:** Count the total number of candidates who have failed in the exam.”*male” is utilized to discover the cells which end with a male.