# COUNTIF vs COUNTIFS in Excel

> COUNTIF counts cells that meet one condition. COUNTIFS counts rows that meet several conditions at once.

Source: https://spreadsheetpractice.com/functions/compare/countif-vs-countifs · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

COUNTIF counts cells that meet one condition. COUNTIFS counts rows that meet several conditions at once. COUNTIFS with a single pair does exactly what COUNTIF does, so many people just use COUNTIFS everywhere.

## The differences

|  | COUNTIF | COUNTIFS |
|---|---|---|
| Conditions | One | One or more, all of which must be true |
| Arguments | range, criteria | criteria_range1, criteria1, criteria_range2, criteria2, … |
| OR logic (East or West) | Add two COUNTIFs | Add two COUNTIFS |
| Ranges | One range | Every criteria range must be the same size |
| Available in | Every version | Every version |

## Same data, side by side

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=COUNTIF(A2:A8,"East")` | 4 | One condition: orders from East |
| F3 | `=COUNTIFS(A2:A8,"East",B2:B8,"Shipped")` | 3 | Two conditions: East and shipped |
| F4 | `=COUNTIFS(A2:A8,"East",C2:C8,">500")` | 3 | A text condition and a number condition together |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Region | Status | Amount |  | Question | Result |
| 2 | East | Shipped | $820 |  | East orders | 4 |
| 3 | West | Pending | $340 |  | East and shipped | 3 |
| 4 | East | Pending | $1,150 |  | East over $500 | 3 |
| 5 | North | Shipped | $610 |  |  |  |
| 6 | East | Shipped | $275 |  |  |  |
| 7 | West | Shipped | $990 |  |  |  |
| 8 | East | Shipped | $1,400 |  |  |  |

## When to use each

### Choose COUNTIF when

There is one condition and you want the shortest formula.

### Choose COUNTIFS when

There are two or more conditions, or you expect to add one later.

## The functions

- [COUNTIF](https://spreadsheetpractice.com/functions/countif): COUNTIF counts the cells in a range that meet one condition: tickets marked "Open", scores of 70 or more, product names containing "lamp". Every current version.
- [COUNTIFS](https://spreadsheetpractice.com/functions/countifs): COUNTIFS counts the rows where every condition is true: orders that are from the East region and shipped, deals between $500 and $1,000. Every current version.

## Questions

### How do I count with OR in COUNTIFS?

Add two counts: =COUNTIF(A2:A8,"East")+COUNTIF(A2:A8,"West"). One COUNTIFS always means AND.

### Why does COUNTIFS return #VALUE!?

The criteria ranges are different sizes. Make every range cover the same rows, such as A2:A8 and B2:B8.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
