Excel formula builder
COUNTIFS Formula Builder
Count rows that match one, two, or three criteria using deterministic COUNTIFS formula construction.
Builder inputs
Add criteria range and criteria value pairs. Empty optional pairs are ignored.
=COUNTIFS(C2:C100, "Complete", B2:B100, "Maya")=COUNTIFS(C2:C100, "Complete", B2:B100, "Maya")COUNTIFS uses paired criteria range and criteria value arguments.How this formula works
- COUNTIFS counts rows only when every criteria pair is true.
- Text criteria are quoted automatically.
- Criteria can also use operators such as >=100 or <>Closed.
Sample data
| Task | Owner | Status | Due Date |
|---|---|---|---|
| Import leads | Maya | Complete | 2026-01-06 |
| Clean headers | Nico | In Progress | 2026-01-08 |
| Review budget | Maya | Complete | 2026-01-12 |
| Publish report | Iris | Blocked | 2026-01-15 |
Common mistakes
- Every criteria range must have the same number of rows.
- COUNTIFS is for row counts, not sums. Use SUMIFS when you need to add values.
- Blank criteria fields should be removed instead of leaving an empty range/value pair.
Related formulas
FAQ
Are these formulas generated with AI?
No. The builder uses deterministic TypeScript functions in the browser and does not call any AI API.
Do I need to upload my spreadsheet?
No. Enter ranges and criteria manually. The site does not upload, store, or process spreadsheet files.
Can I copy the generated formula?
Yes. Each output includes a copy button so you can paste the formula into Excel or Google Sheets.