Loading…
Loading…
COUNTIFS counts the rows that meet all of several conditions. Unlike SUMIFS there is no sum range: just pairs of range and criteria. Criteria can be text, comparisons like ">=700" or "not equal" like "<>North".
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)
Example: =COUNTIFS(A2:A10,"Laptop",B2:B10,"<>North") counts Laptop rows outside the North.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.