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