Google Sheets | SUM | FILTER | Function | OR Logic to Filter Data | Example | Spreadsheet | Tutorial

The Google Sheets FILTER function does not allow to use the OR logic directly. For example, say you want to sum the sales revenue from product A, product B, or both. You cannot use SUM and FILTER directly for this task. However, a workaround involves the use of + which is the OR operator
for this task.

If you wish to get more info on FILTER or SUM functions, please refer
to their exclusive, step-by-step tutorials whose links are given below.

-------------------------------------
How to Use FILTER in Google Sheets?

Use FILTER to filter data based on one or more conditions:

-------------------------------------
How to Use SUM in Google Sheets?

SUM enables to get the sum numbers in one or more ranges:

-------------------------------------
How to Use IFS in Google Sheets?

IFS allow multiple logical expressions:

-------------------------------------
How to Use IF in Google Sheets?

Use IF to compare one value with another:

-------------------------------------
How to Use IF with AND in Google Sheets?

Use IF with AND to Use Multiple Logical Expressions in IF:

-------------------------------------
How to Create a Pivot Table in Google Sheets?

Create a pivot table for calculation and in-depth data analysis:

-------------------------------------
Which one to Use? A Pivot Table, or COUNTBLANK Function, to Count Blank Cells in Google Sheets:

Gives steps to use a pivot table or COUNTBLANK to count blank cells:

-------------------------------------
How to Use a Pivot Table to Sum by Rows or Columns without using Formula in Google Sheets?

Sum numbers by rows and or columns easily, using a pivot table:

-------------------------------------
How to Create a Pivot Table to Get Maximum Value without Using Formula in Google Sheets?

A pivot table assists to get the maximum value in a data range without using a formula:

-------------------------------------

A solution to use a condition with OR logic in FILTER, to sum numbers, is to use the + operator and nest FILTER inside SUM.

FILTER Function

It is a powerful function to filter data, based on one or more conditions.

Let's look at the syntax of the FILTER function:

=FILTER(range, condition1, [condition2, …])

range is an area of a spreadsheet from which to filter data.

condition1 is the first condition a cell in a range has to fulfill to filter the
corresponding data.

condition2 is optional.

If two conditions are used, FILTER uses AND logic. That is, both the conditions
should be true for the FILTER function to filter data

Example

=FILTER(A3:A15, B3:B15="Maths", C3:C15=90)

The filter function will return those values from the range A3 to A15 whose
corresponding values in the ranges B3 to B15 and C3 to C15 are Maths and 90 respectively.

SUM Function

SUM sums numbers in one or more columns or rows.

The format of the SUM function formula is:

=SUM(value1, [value2, …])

value1 can be, for example, a hard-coded number, cell address, range, or a function that returns a number.

Example

=SUM(A2:A6, B2:B11)

SUM will return the sum of numbers in the range A2 to A6 and B2 to B11.

Nest FILTER inside SUM to sum numbers, using the + operator to use OR logic inside FILTER.

Take a look at this video tutorial, which uses the Google Sheets FILTER and SUM functions, and + operator for OR logic, to sum numbers, with examples.