1
00:00:00,080 --> 00:00:03,702
When you filter multiple conditions in Google Sheets, decide whether

2
00:00:03,702 --> 00:00:06,237
every condition must match or just one.

3
00:00:06,237 --> 00:00:10,220
Our fictional order list gives a clear answer: Open orders over

4
00:00:10,220 --> 00:00:14,204
one hundred are three rows; Open or Urgent orders are five.

5
00:00:14,204 --> 00:00:18,188
We'll check the IDs instead of trusting the filter icon.

6
00:00:18,788 --> 00:00:22,185
Import the downloadable CSV as a new practice sheet.

7
00:00:22,185 --> 00:00:27,470
It has headers Order ID, Status, Amount, and Priority, followed by seven fictional orders.

8
00:00:27,470 --> 00:00:31,623
Read the answer check before filtering: the AND result should be

9
00:00:31,623 --> 00:00:35,775
orders one oh two, one oh five, and one oh seven.

10
00:00:36,375 --> 00:00:40,722
Select the complete table including its header and create a filter.

11
00:00:40,722 --> 00:00:43,488
In the Status column, show only Open.

12
00:00:43,488 --> 00:00:47,045
In Amount, choose a greater-than-one-hundred condition.

13
00:00:47,045 --> 00:00:51,391
Column filters narrow the same row set, so this demonstrates AND:

14
00:00:51,391 --> 00:00:54,157
a visible row must satisfy both criteria.

15
00:00:54,757 --> 00:01:00,225
The visible order IDs should be ORD-102, ORD-105, and ORD-107.

16
00:01:00,225 --> 00:01:05,693
ORD-101 is Open but only eighty dollars, so it should be absent.

17
00:01:05,693 --> 00:01:11,582
ORD-103 exceeds one hundred but is Closed, so it should also be absent.

18
00:01:11,582 --> 00:01:16,209
This negative check catches a filter applied to the wrong column.

19
00:01:16,809 --> 00:01:21,769
Clear the UI filters and use a separate output area for the OR result.

20
00:01:21,769 --> 00:01:25,666
FILTER can combine Boolean tests by adding them and checking whether

21
00:01:25,666 --> 00:01:27,792
the sum is greater than zero.

22
00:01:27,792 --> 00:01:31,689
For the seven practice rows, use the displayed formula; it checks

23
00:01:31,689 --> 00:01:34,878
Open in column B or Urgent in column D.

24
00:01:35,478 --> 00:01:42,755
The OR result should contain ORD-101, ORD-102, ORD-104, ORD-105, and ORD-107.

25
00:01:42,755 --> 00:01:46,849
ORD-105 satisfies both conditions but should appear once.

26
00:01:46,849 --> 00:01:52,307
If the formula fails to parse, check your sheet's formula separators

27
00:01:52,307 --> 00:01:58,219
and range sizes; do not substitute the two-column UI filter for OR.

28
00:01:58,819 --> 00:02:00,613
The sample has seven orders.

29
00:02:00,613 --> 00:02:05,634
AND gives exactly three IDs: one oh two, one oh five, one oh seven.

30
00:02:05,634 --> 00:02:09,938
OR gives exactly five, including one oh one and one oh four.

31
00:02:09,938 --> 00:02:13,884
If your result differs, inspect the condition columns and row boundaries

32
00:02:13,884 --> 00:02:17,112
before using the filtered list for any real decision.