1
00:00:00,080 --> 00:00:04,849
Google Sheets may show #N/A with a no-matches message when FILTER

2
00:00:04,849 --> 00:00:07,417
finds no rows that satisfy its condition.

3
00:00:07,417 --> 00:00:10,352
That does not prove the function is broken.

4
00:00:10,352 --> 00:00:14,388
In this fictional task list, the formula asks for Approved tasks

5
00:00:14,388 --> 00:00:18,057
even though the status column contains Open, Closed, and Waiting.

6
00:00:18,057 --> 00:00:22,826
We will count the matches, correct the criterion, and check the returned IDs.

7
00:00:23,426 --> 00:00:27,319
Import the companion CSV into a new Google Sheet and keep

8
00:00:27,319 --> 00:00:29,443
the three headers in row one.

9
00:00:29,443 --> 00:00:34,044
Column A holds task IDs, B holds descriptions, and C holds the status.

10
00:00:34,044 --> 00:00:36,875
The data is A one through C six.

11
00:00:36,875 --> 00:00:40,414
Two source rows are Open: TK-401 and TK-403.

12
00:00:40,414 --> 00:00:44,307
Use a blank area beginning at E two for the FILTER

13
00:00:44,307 --> 00:00:47,139
output so the result has room to expand.

14
00:00:47,739 --> 00:00:51,879
In E two, enter the practice formula that asks for Approved.

15
00:00:51,879 --> 00:00:56,773
Google documents that FILTER returns #N/A when no values satisfy the conditions.

16
00:00:56,773 --> 00:01:00,914
The exact formula uses A two through C six for five

17
00:01:00,914 --> 00:01:05,431
data rows and C two through C six for five status tests.

18
00:01:05,431 --> 00:01:09,572
Inspect the error text; do not replace the formula with IFERROR

19
00:01:09,572 --> 00:01:11,077
before finding the cause.

20
00:01:11,677 --> 00:01:15,482
In a separate blank cell, enter COUNTIF over C two through

21
00:01:15,482 --> 00:01:16,865
C six for Approved.

22
00:01:16,865 --> 00:01:18,249
It should return zero.

23
00:01:18,249 --> 00:01:22,053
Change the criterion to Open and the count should be two.

24
00:01:22,053 --> 00:01:25,512
This independent count tells us whether the current condition should

25
00:01:25,512 --> 00:01:28,624
return any rows before we modify the FILTER formula.

26
00:01:28,624 --> 00:01:32,429
It does not prove that every returned column is correct, so

27
00:01:32,429 --> 00:01:34,504
we still inspect the final result.

28
00:01:35,104 --> 00:01:38,518
Replace Approved with Open in the E two formula.

29
00:01:38,518 --> 00:01:43,829
The output should fill E two through G three with two complete task rows.

30
00:01:43,829 --> 00:01:49,519
The first ID is TK-401, Send estimate; the second is TK-403, Check invoice.

31
00:01:49,519 --> 00:01:53,692
If you get a different count, inspect C two through C

32
00:01:53,692 --> 00:01:55,968
six and the typed criterion again.

33
00:01:56,568 --> 00:02:00,415
Google's FILTER documentation says each condition must have the same

34
00:02:00,415 --> 00:02:03,563
length as the source range along the filtered direction.

35
00:02:03,563 --> 00:02:07,411
Here A two through C six has five data rows, so

36
00:02:07,411 --> 00:02:10,908
C two through C six must also cover five rows.

37
00:02:10,908 --> 00:02:14,756
A condition that stops at C five tests only four rows.

38
00:02:14,756 --> 00:02:20,002
Fix the range boundary rather than treating every FILTER error as a no-match case.

39
00:02:20,602 --> 00:02:27,227
The independent answer check contains TK-401 and TK-403 in that order, with statuses Open.

40
00:02:27,227 --> 00:02:31,368
The other three tasks should not appear in the result.

41
00:02:31,368 --> 00:02:35,923
Zero matches for Approved was a legitimate outcome for that criterion;

42
00:02:35,923 --> 00:02:38,821
two Open rows are the intended result.

43
00:02:38,821 --> 00:02:42,962
If a future filter can legitimately return nothing, handle that

44
00:02:42,962 --> 00:02:45,861
deliberately after confirming your condition and ranges.