FILTER with multiple conditions
IntermediateSales managers often need a short follow-up list before a pipeline meeting, especially when they want to focus on the most important deals without scanning the full transaction table. In this exercise, you'll build that kind of focused report with FILTER.
FILTER uses this structure:
=FILTER(array, include, [if_empty])
Use the sales table to return the records that match the follow-up criteria shown in the report section. The results area already includes headers, so your formula should return only the matching records beneath them.
Your task:
Enter one FILTER formula in A15 that produces the manager's follow-up list and lets the results spill through the output block automatically.
Need some help?
Hint 1
The filter should return rows from the full sales table, but the logical test only needs to check the columns that contain the criteria.
Hint 2
Build one test for the region: C2:C11="East", and another for the amount: E2:E11>5000.
Hint 3
To require both tests at the same time, multiply them inside the include argument: (condition 1)*(condition 2). In FILTER, that asterisk pattern works like AND logic for row-by-row criteria.
FILTER with multiple conditions
IntermediateSales managers often need a short follow-up list before a pipeline meeting, especially when they want to focus on the most important deals without scanning the full transaction table. In this exercise, you'll build that kind of focused report with FILTER.
FILTER uses this structure:
=FILTER(array, include, [if_empty])
Use the sales table to return the records that match the follow-up criteria shown in the report section. The results area already includes headers, so your formula should return only the matching records beneath them.
Your task:
Enter one FILTER formula in A15 that produces the manager's follow-up list and lets the results spill through the output block automatically.
Need some help?
Hint 1
The filter should return rows from the full sales table, but the logical test only needs to check the columns that contain the criteria.
Hint 2
Build one test for the region: C2:C11="East", and another for the amount: E2:E11>5000.
Hint 3
To require both tests at the same time, multiply them inside the include argument: (condition 1)*(condition 2). In FILTER, that asterisk pattern works like AND logic for row-by-row criteria.