Conditions as 1s and 0s: (range="x")*1 and the Double Unary --
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- 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