CountIFS formula

Returns the count of a range depending on multiple criteria.

How to use?

SYNTAX: =COUNTIFS(criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])
criteria_range1 - The range to check against 'criterion1'.
criterion1 - The pattern or test to apply to 'criteria_range1'.
criteria_range2… - [optional] repeatable - Additional ranges to check.
criterion2… - [optional] repeatable - Additional criteria to check.

Practice Sheet

The below sheet is view only mode, please make a copy to practice.

Copy of Countifs Function

Make a copy

Page updated

Google Sites

Report abuse