Quick Answer & Formula
Excel
Sheets
Beginner
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2, ...]) COUNTIFS counts the number of rows that satisfy all specified conditions. For date ranges, specify the date column twice with ">=" & StartDate and "<=" & EndDate.
COUNTIFS Function in Excel & Google Sheets
The COUNTIFS function counts rows that satisfy multiple conditions simultaneously.
1. Multiple Text Conditions
To count active engineering employees:
=COUNTIFS(B2:B100, "Engineering", C2:C100, "Active")2. Counting Orders Within a Numeric Value Range
To count deals between $10,000 and $50,000:
=COUNTIFS(D2:D100, ">=10000", D2:D100, "<=50000")
?
Frequently Asked Questions
How do I count non-blank cells with criteria?
Use "<>" as the criteria to count non-empty cells: =COUNTIFS(A2:A100, "East", B2:B100, "<>").