Explanation
In this example, the goal is to sum values in matching columns and rows.
In the latest version of Excel, theFILTER functionis another option.
Both approaches are explained below.
Next, the two arrays are multiplied together.
This formula works in two steps.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
Related videos
FILTER function basic example
Boolean operations in array formulas
