
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.