Excel FunctionsLesson 81Free preview
COUNTIFS
This lesson is part of Excel · All levels
Summary
COUNTIFS is an Excel function that calculates the number of cells that meet multiple criteria at once. Each pair of ranges and criteria is given in sequence, and all criteria must be met (logic AND). This function is a development of COUNTIF.
Key points
- Syntax: COUNTIFS(range1, criteria1, range2, criteria2, ...)
- All criteria must be met together.
- All ranges should have the same number of lines
- The text, the numbers, the logical criteria are all supported
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.