Excel Magic Trick 1097

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


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.


Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 455 times – 2 MB

Be the first to comment

Leave a Reply