Distinct Counts with SUMPRODUCT(1/COUNTIF)
This lesson is part of the course
In this lesson
You count how many different customers ordered, how many promo codes were used (with blanks in the column), the distinct customers of one region and how many customers came back.
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