Home/Formulas/Math/COUNTIFS
Mathmedium

COUNTIFS()

Returns the count of a range depending on multiple criteria.

Syntax
fx
=COUNTIFS(criteria_range1, criterion1, ...)
Try it
F2
→
7
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • All criteria ranges must be the same size. Mismatched ranges return #VALUE!.
  • Conditions are AND-ed together. There's no built-in OR; sum two COUNTIFS calls instead.
  • Wildcards work the same as COUNTIF: * for anything, ? for one char, ~ to escape.
Related formulas
COUNTIF()
Returns a conditional count across a range.
SUMIFS()
Returns the sum of a range depending on multiple criteria.
Used by
SUMIFS()
Returns the sum of a range depending on multiple criteria.
COUNTIF()
Returns a conditional count across a range.
More Math formulas →Keyboard shortcuts for Sheets →