How to Use COUNTIFS() in Google Sheets

Description

Returns the count of a range depending on multiple criteria.

How To Actually Use COUNTIFS() in Sheets

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

Try COUNTIFS yourself

In the range A1:A10, count how many times the value 'Apple' appears in column A and the value 'Red' appears in column B (B1:B10). Your formula should return the correct count.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

3 More Ways to Count in Google Sheets

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

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

Transcript-matched member videos for COUNTIFS(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sh...

Beginner

COUNTA() COUNTIF()

Unlock these tutorials

Learn more about the COUNTIFS() formula:

Generate a COUNTIFS() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses COUNTIFS(). 2 free AI generations, no signup. Members get unlimited use.

Generate a COUNTIFS() formula

How to Use COUNTIFS() in Google Sheets

Try COUNTIFS yourself

3 More Ways to Count in Google Sheets

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

3 Ways to Count in Google Sheets