Highline Excel 2013 Class Video 17

Introduction To SUMPRODUCT Function

DESCRIPTION

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.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 2 times – 21 MB




Be the first to comment

Leave a Reply