FILTER practice

FILTER returns the rows of a range that meet one or more conditions, in Google Sheets. Below are the 3 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

FILTER(range, condition1, [condition2], ...)

What people get wrong

Each condition is a range of TRUE/FALSE values the same height as the data; combine them as separate arguments, not with AND.

Google Sheets exercises that use FILTER

• Sum a filtered listLevel 4Pro
• Two conditions in FILTERLevel 4Pro
• Join the confirmed namesLevel 5Pro

Often used together with: COUNTA, JOIN, SUM