Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

COUNTIFS

Aggregation

Count rows that meet multiple conditions.

Difficulty

Amateur
Excel file

1What is it?

COUNTIFS counts how many rows satisfy every condition you give it — the counting sibling of SUMIFS. Great for operational metrics: open invoices, deals in a stage, headcount by team.

2What it looks like

COUNTIFS(criteria_range1, criteria1, …)
criteria_range1
The column to test.
criteria1
The condition to count.

3When you use it

  • Count invoices over 30 days past due.
  • Count deals by stage or owner.
  • Count rows between two dates (two criteria on the date column).

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

Start simple · 1 of 2

Count the open invoices.

C2
fx
=COUNTIFS(A2:A6, "Open")3
ABC
1StatusDaysResult
2Open453
3Open12
4Paid0
5Open60
6Paid0

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

5Common errors

#VALUE!Criteria ranges differ in size.

Fix: Make all criteria ranges the same height.

0 (unexpected)Type or spacing mismatch in the criteria.

Fix: Match the data type and quote operators (">30").

6Better functions & alternatives

  • SUMPRODUCT — Counting with conditions in older Excel.
  • PivotTable — Count rows across many dimensions interactively.

Want COUNTIFS already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →