Lesson 12 · Conditional Math
COUNTIFS Function
Practice COUNTIFS in Google Sheets: count rows that meet multiple conditions, including between two numbers.
Count orders from the West region that were also over $500. Answer in E2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Counting with multiple conditions
=COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
COUNTIFS counts rows where all the conditions are true at the same time. You give it pairs: a range, then the condition for that range.
Every range must be the same size, because COUNTIFS compares them row by row.
Between two values: use the same range twice with two conditions:
=COUNTIFS(B2:B13, ">=30", B2:B13, "<=39")