Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

min) Boolean Logic..
min) AND criteria = Multiplication = All Logical Test Must Be TRUE..
min) SUMPRODUCT can do AND Criteria..
min) COUNTIFS, SUMIFS, AVERAGEIFS &.
min) How IF function calculates AND Criteria for array calculations:.
min) AND Can Have 2 Or More Logical Tests..
min) OR Criteria = Adding = At Least 1 Logical Test Must Be TRUE..
min) Boolean Adding for OR Criteria when result can be 2 or more..
min) SUMPRODUCT with Boolean Adding for OR Criteria when result can be 2 or more..
min) Formula goal: Count transactions that have 'Seattle' or 'Pro2'. But no 'double counting'..
min) Calculating notes for Array Formula: =SUMPRODUCT(--(((B76:B80=F77)+(C76:C80=F79)) Greater Than 0))..
min) IF function logical_test argument with Boolean Adding for OR Criteria when result can be 2 or more..
min) Formula goal: Find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold..
min) Could we use DMAX to find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold?.
min) Calculation Summary for: =MAX(IF((B133:B137=F134)+(C133:C137=G134),D76:D80)).
min) OR Criteria When There Can Never Be 2 TRUEs.
min) Four Formulas for Counting with Mutually Exclusive OR Criteria..
min) MATCH function with range of values (array) in lookup_value argument..
min) Any math operation converts TRUEs and FALEs to 1s and 0s..
min) Timing Different Ways of Converting TRUEs and FALSEs to 1s and 0s..
min) AND and OR Criteria guidelines..