Excel COUNTIFS Formula
Learn how to use the COUNTIFS formula in Excel to count rows that match one or more conditions.
Syntax
Copy formula manually
=COUNTIFS(criteria_range1, criteria1, [criteria_range2], [criteria2])
Example
=COUNTIFS(A:A, "Finance")
Try This Formula Online
Paste sample CSV data below and test how this formula works directly in your browser.
Result
1
COUNTIFS counts cells or rows that meet one or more conditions. It is useful for counting matching records in HR data, finance sheets, sales reports, survey results, inventory files, and business datasets.
Formula Examples
| Input | Formula | Output |
|---|---|---|
| Department = Finance | =COUNTIFS(A:A, "Finance") | Number of Finance rows |
| Region = North and Status = Active | =COUNTIFS(A:A, "North", B:B, "Active") | Number of active rows in North region |