The named rangethingsis not required.
It is used only for convenience and can be expanded as needed to include additional criteria.
The article below explains several ways to solve this problem.
Read more about this topic here:Why SUMPRODUCT?
The result is delivered to theSUM functionwhich returns a final result.
Seethis examplefor more details.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
MATCH supports approximate and exact matching, andwildcards(* ?)
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
