AND vs OR Logic in Arrays: Multiply, Add and the SIGN Trick
This lesson is part of the course
In this lesson
You filter Tidewell's orders with AND (multiply), OR on one column, OR on two columns without double counting, and a mixed (A OR B) AND C test.
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