COUNTIFS counts positions where all specified criteria are met across corresponding ranges.
Quick Example
=COUNTIFS(Criteria Range 1, Criteria 1, ...)
- Criteria Range 1: Range of cells that houses the (first) criteria
- Criteria 1: The criteria to be counted
These conditional functions evaluate criteria when calculating their result.
- other examples include: SUMIFS, AVERAGEIFS, and MAXIFS
Use COUNTIFS or SUMIFS when you need one or more criteria pairs. COUNTIF and SUMIF remain valid for single-condition tasks; check the argument order for the function you choose.
Learn More About Excel
Master Excel through our Microsoft Excel classes with guided exercises. Sign up and grow your marketability today!