# ExcelHow

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

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

• `criteria_range1`This is a required argument.  the first range in which to apply the associated criteria.
• `criteria1` – This is a required argument.  the first critiria to use on criteria_range1
• `criteria_range2, criteria2`, …    Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

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")`