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.