# 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.

1. A person should be female.
2. 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.    