Formulas > =COUNTIFS()

How To Use COUNTIFS() Function in Google Sheets


Returns the count of a range depending on multiple criteria.

Common questions about the COUNTIFS Formula:
1. What is the syntax for the COUNTIFS formula?
2. How do you use multiple criteria with the COUNTIFS formula?
3. How do you sum data with the COUNTIFS formula?

How can the COUNTIFS formula be used appropriately:
The COUNTIFS formula can be used to count cells that meet multiple criteria in two or more ranges. It can also be used to count cells that are blank or have specific text.

How can the COUNTIFS formula be commonly mistyped:
The COUNTIFS formula can be commonly mistyped as COUTIFS, COUNIFS, COUTFIS, CONUTIFS, or COUNTIS.

What are some common ways the COUNTIFS formula is used inappropriately:
The COUNTIFS formula should not be used to sum information, and there should not be more than two criteria in the argument list. The COUNTIFS formula should not be used for formatted text as it will not work correctly.

What are some common pitfalls when using the COUNTIFS formula:
The formula may not work as expected when nested inside of another function, or if the particular worksheet contains merged cells. There are also potential difficulties when dealing with dates, text, and numbers due to incorrect formatting.

What are common mistakes when using the COUNTIFS Formula:
Common mistakes when using the COUNTIFS formula include mistyping the formula name, incorrectly specifying the criteria range, or adding too many criteria.

What are common misconceptions people might have with the COUNTIFS Formula:
One common misconception with the COUNTIFS formula is that it can be used to sum data. The COUNTIFS formula can only count cells that meet the criteria, it cannot be used for any kind of addition. Another common misconception is that the COUNTIFS formula would work in an array because it is an array formula, but it does not.

How To Actually Use COUNTIFS() in Sheets

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

1Better Sheets Tutorial

Learn how to use CountBlank() and more counting formulas.

Learn more about the COUNTIFS() formula:

Generate a COUNTIFS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.