Capstone: A Weighted Supplier Scorecard with a Ranked Chart
This lesson is part of the course
In this lesson
You score Tidewell's eight green-coffee suppliers with weighted criteria, rank them, pick the best supplier that meets a minimum quality and chart the scores largest first.
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