Counting with Multiple Criteria and Partial Text: ISNUMBER(SEARCH())
This lesson is part of the course
In this lesson
You count product lines whose name contains a word, combine the text test with a region, add an OR on two words and work out a weighted revenue per bag.
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