Master Excel's SUMPRODUCT Formula

Master Excel's SUMPRODUCT Formula

 

 

Quickly learn how Excel's SUMPRODUCT formulas works. This video is part of a series that belongs to my Advanced Training course called "Advanced Excel: Top tips and formulas".   The classical use of Excel's SUMPRODUCT function is to do a sum of multiplications.  

 

In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you from unnecessary "workarounds" in your Excel files. It will also show you the SUMPRODUCT formula in slow motion.

 

Related topics:

• Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder 
• Link Page Header to Cell Value with Excel VBA 
• Excel ActiveX Combo Box to Select Worksheets with VBA 
• Excel VBA FIND Function (and how to handle if value NOT found)