Learn Excel
EN
EnglishENNederlandsNL

Home › Excel functions › COUNTIFS

COUNTIFS in Excel: Count with Multiple Criteria

COUNTIFS counts the rows that meet all of your conditions: orders that are shipped and above $100, tickets opened this month and still open. It's the multi-condition version of COUNTIF.

COUNTIFS · 2 min read
In this guide
  1. COUNTIFS syntax
  2. Basic example
  3. Count between dates
  4. Criteria types
  5. OR conditions
  6. Common mistakes
  7. FAQ

COUNTIFS syntax

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Pairs of a range and a condition. All ranges must be the same size; a row is counted only when every condition is true for that row.

Basic example

ABC
1DateRegionSales
2Jan 8, 2026North1,200
3Jan 15, 2026South800
4Feb 3, 2026North950
5Feb 20, 2026East450
6Mar 2, 2026South700
=COUNTIFS(B2:B6, "North", C2:C6, ">=1000")

Two rows are North, but only one has sales of 1,000 or more, so the result is 1.

Count between two dates

=COUNTIFS(A2:A6, ">="&DATE(2026,2,1), A2:A6, "<="&DATE(2026,2,28))

Returns 2: the two February entries. With dates in cells: ">="&F1 and "<="&F2.

More criteria

  • Not equal: =COUNTIFS(B2:B6, "<>North") returns 3.
  • Wildcards: "*urgent*" counts cells containing "urgent". See wildcards.
  • Not empty: "<>"; empty: "".
  • Overdue and not done: =COUNTIFS(D2:D100, "<"&TODAY(), E2:E100, "<>Done")

OR conditions

COUNTIFS uses AND logic. For OR, add separate counts:

=COUNTIFS(B2:B6, "North") + COUNTIFS(B2:B6, "East")

Returns 3. Or shorter: =SUM(COUNTIFS(B2:B6, {"North","East"})). Make sure the OR options can't both be true for the same row, or it gets counted twice.

Common mistakes

  • #VALUE!: ranges of different sizes.
  • Too low: numbers or dates stored as text, or extra spaces in the data (use TRIM).
  • Operator with a cell doesn't work: write ">"&F1, not ">F1".

Frequently asked questions

What's the difference between COUNTIF and COUNTIFS?

COUNTIF handles one condition; COUNTIFS handles one or more. COUNTIFS with a single condition works exactly like COUNTIF.

Is COUNTIFS case-sensitive?

No. "north" and "North" are treated the same.

How many criteria can COUNTIFS have?

Up to 127 range/criteria pairs.