Formulas > =COUNTIFS()
How to Use COUNTIFS() in Google Sheets
Description
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.
Hints (2)
-
Remember to specify both criteria ranges and their corresponding criteria.
-
Make sure to use quotation marks for text criteria.
1 Better Sheets Tutorial
3 More Ways to Count in Google Sheets
Learn how to use CountBlank() and more counting formulas.
COUNTBLANK()
COUNTIFS()
COUNTUNIQUE()
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