Table of Contents
Google Sheets is a powerful spreadsheet software that allows users to organize and analyze data. One useful feature of Google Sheets is the ability to filter data using multiple conditions. This means that users can specify multiple criteria to narrow down their data and only display the relevant information. This can be done by using the “Filter” function, which allows users to select and combine different conditions, such as text, numbers, and dates. This feature is especially useful for large data sets, as it allows for efficient and precise data analysis.
Google Sheets: Filter with Multiple Conditions
You can use the following methods in Google Sheets to filter data with multiple conditions:
Method 1: Filter for Rows that Meet Multiple Conditions
=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.
Method 2: Filter for Rows that Meet One of Multiple Conditions
=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” or the value in column C is less than 20.
The following example shows how to use each method in practice with the following dataset in Google Sheets:
Example 1: Filter for Rows that Meet Multiple Conditions
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.
Example 2: Filter for Rows that Meet One of Multiple Conditions
We can use the following formula to filter for all rows where the team is equal to “A” or 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” or the points is less than 20.
Additional Resources
Cite this article
stats writer (2024). “How do I filter data in Google Sheets using multiple conditions?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-filter-data-in-google-sheets-using-multiple-conditions/
stats writer. "“How do I filter data in Google Sheets using multiple conditions?”." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-filter-data-in-google-sheets-using-multiple-conditions/.
stats writer. "“How do I filter data in Google Sheets using multiple conditions?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-filter-data-in-google-sheets-using-multiple-conditions/.
stats writer (2024) '“How do I filter data in Google Sheets using multiple conditions?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-filter-data-in-google-sheets-using-multiple-conditions/.
[1] stats writer, "“How do I filter data in Google Sheets using multiple conditions?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. “How do I filter data in Google Sheets using multiple conditions?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.