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.
Full article: How to use SUMPRODUCT with multiple criteria
