Excel Magic Trick 1097

AND & OR Criteria Together for Counting, Adding, Conditional Formatting


  • (00:11) AND and OR Criteria.

    (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation

    (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation

    (04:22) Conditional Format the row with AND and OR functions and a comparative operator array operation and Mixed Cell References. See an array formula with a comparative Operator Array Operation inside the OR function.

    (06:51) Learn that Array Formulas work without Ctrl + Shift + Enter in the Conditional Formatting dialog box.