Introduction To SUMPRODUCT Function

Topics: AND and OR Criteria. Important Functions like: SUMIFS, IF, AND, OR, and more…

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