SUMPRODUCT Basics: Weighted Totals and Weighted Averages
All lessons
- SUMPRODUCT Basics: Weighted Totals and Weighted AveragesFree
- Conditions as 1s and 0s: (range="x")*1 and the Double Unary -- Pro
- AND vs OR Logic in Arrays: Multiply, Add and the SIGN Trick Pro
- Counting with Multiple Criteria and Partial Text: ISNUMBER(SEARCH()) Pro
- Distinct Counts with SUMPRODUCT(1/COUNTIF) Pro
- Two-Way Conditional Sums: Row and Column Criteria in One Formula Pro
- Array MAX and MIN with Conditions, and MATCH(MAX(…)) Position Lookups Pro
- Capstone: A Weighted Supplier Scorecard with a Ranked Chart Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…