You can use the following basic syntax in Google Sheets to use the **FILTER** function with **AND **logic:

=FILTER(A1:C10, A1:A10="A", C1:C10<20)

This filter returns the rows in the range A1:C10 where the value in column A is equal to “A” **and **the value in column C is less than 20.

The following example shows how to use this syntax in practice.

**Example: How to Use Filter Function with AND in Google Sheets**

Suppose we have the following dataset in Google Sheets that contains information about various basketball players:

We can use the following formula to filter for all rows where the team is equal to “A” **and **the points is less than 20:

=FILTER(A1:C10, A1:A10="A", C1:C10<20)

The following screenshot shows how to use this formula in practice:

The only rows returned are the ones where the team is equal to “A” **and **the points is less than 20.

We can also use more commas in the **FILTER** function to apply even more **AND **operators.

For example, we can use the following syntax to filter for rows where the team is equal to “A” **and **the position is “Forward” **and** points is greater than 24:

=FILTER(A1:C10, A1:A10="A", B1:B10="Forward", C1:C10>24)

The following screenshot shows how to use this formula in practice:

This **FILTER** function returns the two rows in the original dataset where all three of the conditions are met.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Use FILTER Function with OR

Google Sheets: How to Filter for Cells that Contain Text

Google Sheets: How to Use SUMIF with Multiple Columns