Sheets ExercisesFree · Lesson 14: FILTER
0 pts
✕
0
Step 1 of 4

Return open invoices

In F2, filter A2:D7 to rows where C2:C7 equals Open. The result will spill into four columns.

Show formula shape
=FILTER(source range, condition range="value")
100%
F2fx
A
B
C
D
E
F
G
H
I
J
1
Invoice
Client
Status
Amount
Filtered results
2
I-301
Acme
Open
120
3
I-302
Birch
Paid
80
4
I-303
Cedar
Open
240
5
I-304
Acme
Paid
95
6
I-305
Birch
Paid
180
7
I-306
Cedar
Open
130
8
9
10
11
12
13
14
15
16
17
18
Invoice queue
F2