Highline Excel 2013 Class Video 17

Introduction To SUMPRODUCT Function

TOPICS IN THIS VIDEO

  • (00:35) Bank Deposit Example: Multiply and then Add in Succession.
    (02:37) Grade Book Weighted Average Example: Multiply and then Add in Succession.
    (03:30) Accounting Budget Weighted Average Example: Multiply and then Add in Succession.
    (04:56) OR Criteria SUMPRODUCT and SUMIFS: Add the results of an array operation.
    (06:49) Single Cell Profit Formula: SUMPRODUCT and Math Operation subtraction: Add the results of an array operation.