How to Filter with Multiple Conditions in Google Sheets

To filter with multiple conditions in Google Sheets, you can use the FILTER function combined with different conditions. Here's a step-by-step guide on how to do this:

1. Open your Google Sheet.
2. Identify the range of data you want to filter.
3. Choose an empty cell where you want to display the filtered results.
4. Type the FILTER function along with the conditions you wish to apply.

The syntax for the FILTER function is:

=FILTER(range, condition1, condition2, ...)

• range: The range of data you want to filter.
• condition1, condition2, ...: The conditions you want to apply to the range. You can use multiple conditions separated by commas.

Example

Let's say you have a list of sales data, and you want to filter the data to show rows where the salesperson is "John Doe" and the sales revenue is greater than $1000. Your data is in the range A1:D10, with columns A (Salesperson), B (Date), C (Product), and D (Revenue).

Here are the steps to filter the data based on the given conditions:

1. Select an empty cell where you want to display the filtered results, like E1.
2. Type the following formula in the selected cell:

=FILTER(A1:D10, A1:A10="John Doe", D1:D10>1000)

3. Press Enter.

The filtered data will now appear in the selected cell and the cells below it, showing only the rows where the salesperson is "John Doe" and the sales revenue is greater than $1000.