COUNTIFS practice

COUNTIFS counts the rows that meet several conditions at once. Below are the 2 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2], ...)

What people get wrong

Every criteria range must be the same size, or the result is #VALUE!.

Google Sheets exercises that use COUNTIFS

• Open high-priority ticketsLevel 2Pro
• Orders between two datesLevel 2Pro