Returns the number of elements within a cell range that meet multiple criteria.

**Sample Usage**

COUNTIFS( B1:B25 ,">10",C1:C25 ,"<20")

COUNTIFS(A4,A5)

**Syntax**

COUNTIFS(range1, criteria1, [range2,..], [criteria2,..])

- range1 - The cells to which the first criteria is applied.

- criteria1 - The pattern or test to apply to the first range.
- range2,.. - [OPTIONAL] The cells to which the respective criteria is applied.

- criteria2,.. - [OPTIONAL] The pattern or test to apply to the respective range.

**Examples**

COUNTIFS( B1:B25 ,">10",C1:C25 ,"<20") returns a count of the number of rows that meet the first criteria, and also the second criteria.

###

**Notes**

- Any additional ranges must contain the same number of rows and columns as range1.
- Ensure that criteria1, criteria2,.. are in quotation marks.
- criteria can contain wildcard characters. Currently, the use of asterisk (*) is supported.
- An asterisk matches any sequence of characters.
- To match an actual asterisk, type a tilde (~) before the character. For example: (~*).