Introducing Excel's one of the most versatile function "SUMPRODUCT function" is to do a sum of multiplications.The good thing about this function is that this i an array function but there is no need to use Ctrl+Shift+Enter to execute this,It works as standard function.
It can act as a conditional SUMIFS,COUNTIFS function or work as a lookup function as INDEX and MATCH does.

Download the Assignment Master Practice Folder here (All Playlist Example at one place)
https://drive.google.com/drive/folder...
(Playlist FolderBasic ExcelTextAdvanced2.xlsx)

Website "http://www.innozant.com"
Let's Connect:
Instagram ►  / innozantoffi.  .
Facebook ►   / innozant  
Twitter ►   / innozant  
Linkedin ►   / inno.  .

#sumproduct #sumproductfunction #innozant #excelsumproduct #exceltricks