How to use SUMPRODUCT with multiple criteria

How to use SUMPRODUCT with multiple criteria

17 June 2018

There are situations where several criteria are required to add up the right numbers. That's straightforward if the numbers are found in a single column using SUMIF. Yet when you find your data in several columns, more complex formulas are needed.

This article shows you how to use SUMPRODUCT with multiple criteria to add numbers from multiple columns.