This post will teach you how to use **Google Sheets COUNTIFS function** with syntax and examples in Google Spreadsheets.

Table of Contents

**Description**

The Google Sheets COUNTIFS function returns the count of cells in a range that meet one or more criteria. It allows to use the criteria with the numeric value or text string, which may be contain the wildcards in text-related criteria, and also support to use the logical operator to build an expression statement for criteria. You also should know that the COUNTIFS function is not case-sensitive.

The COUNTIFS function is a build-in function in Google Sheets and it is categorized as a Math Function.

**Syntax**

The syntax of the COUNTIFS function is as below:

= COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

**Where the COUNTIFS function arguments are:**

This is a required argument. the first range in which to apply the associated criteria.`criteria_range1`

–the first critiria to use on criteria_range1`criteria1`

– This is a required argument.Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.`criteria_range2, criteria2`

, … Optional.

**Note:**

- Each range’s criteria is applied one cell at a time. If all of the first cells meet their associated criteria, the count increases by 1. If all of the second cells meet their associated criteria, the count increases by 1 again, and so on until all of the cells are evaluated.
- If the criteria argument is a reference to an empty cell, the
**COUNTIFS**function treats the empty cell as a 0 value. - You can use the wildcard characters— the question mark (?) and asterisk (*) — in criteria. A question mark matches any single character, and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (
**~**) before the character.

**Google Sheets COUNTIFS Function Examples**

The below examples will show you how to use Google Sheets COUNTIFS Function to count cells that match multiple criteria.

**#1** To count how many rows have numbers that are greater than 50 in range C2:C6, and also the product name is Google Sheets in range A2:A6 , just using the following Google Sheets formula:

=COUNTIFS(A2:A6,"=excel",C2:C6,">4")