Two-Way Conditional Sums: Row and Column Criteria in One Formula
This lesson is part of the course
In this lesson
You pull one region-month figure out of Tidewell's revenue matrix, total a product line for one quarter and fill a region × quarter grid with a single copyable SUMPRODUCT.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- SUMPRODUCT Basics: Weighted Totals and Weighted Averages Locked
- Conditions as 1s and 0s: (range="x")*1 and the Double Unary -- Locked
- AND vs OR Logic in Arrays: Multiply, Add and the SIGN Trick Locked
- Counting with Multiple Criteria and Partial Text: ISNUMBER(SEARCH()) Locked
- Distinct Counts with SUMPRODUCT(1/COUNTIF) Locked
- Two-Way Conditional Sums: Row and Column Criteria in One Formula Locked
- Array MAX and MIN with Conditions, and MATCH(MAX(…)) Position Lookups Locked
- Capstone: A Weighted Supplier Scorecard with a Ranked Chart Locked