See how to:
(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.