Table of Contents
The FILTER function in Google Sheets allows users to extract data from a specified range based on certain criteria. By using the OR logic, multiple criteria can be included in the function to filter data that matches any of the given criteria. This allows for more flexibility and precision in data analysis and organization. By specifying the range and criteria within the function, users can easily customize their data selection and obtain the desired results. This feature is particularly useful for handling large sets of data and conducting complex data analysis in a streamlined manner.
Google Sheets: Use FILTER Function with OR
You can use the following basic syntax in Google Sheets to use the FILTER function with OR 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” or the value in column C is less than 20.
Note: The plus (+) sign is used as an OR operator in Google Sheets.
The following example shows how to use this syntax in practice.
Example: How to Use Filter Function with OR 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” 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.
We can also use more plus signs (+) in the FILTER function to apply even more OR operators.
For example, we can use the following syntax to filter for rows where the team is equal to “A” or the position is “Guard” or points is greater than 15:
=FILTER(A1:C10, (A1:A10="A")+(B1:B10="Guard")+(C1:C10>15))
The following screenshot shows how to use this formula in practice:
This FILTER function returns the rows in the original dataset where any of the three conditions are met.
Cite this article
stats writer (2024). How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-filter-function-in-google-sheets-to-include-multiple-criteria-with-or-logic/
stats writer. "How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-filter-function-in-google-sheets-to-include-multiple-criteria-with-or-logic/.
stats writer. "How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-filter-function-in-google-sheets-to-include-multiple-criteria-with-or-logic/.
stats writer (2024) 'How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-filter-function-in-google-sheets-to-include-multiple-criteria-with-or-logic/.
[1] stats writer, "How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the FILTER function in Google Sheets to include multiple criteria with OR logic?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.