Mastering Excel's SUMPRODUCT Formula | (The Easy Way)

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.
#sumproduct #sumproductfunction #shakeelinformation

[saverakhan]

It is amazing !!!Explained the concept of sumproduct with simplicity

[sidkhan]

Hey great video, the way you thoroughly explain everything amazing and made it easy to understand exactly how it all works. Thank you so much!