This video tutorial walks through 3 different examples of the SUMPRODUCT function. It begins with the classic use of the formula. It then demonstrates 2 more complex examples.
The Excel SUMPRODUCT function sums the product of 1 or more arrays. Excel users have taken it far beyond its initial design and this awesome function can now be found solving many daunting Excel tasks.
Here are the timings of the video.
00:00 – How to use SUMPRODUCT function in Excel
02:00 – Multiple criteria count with SUMPRODUCT
06:33 – Multiple criteria sum with SUMPRODUCT function
Find more great free tutorials at;
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything https://bit.ly/UltimateExcel
Excel VBA for Beginners http://bit.ly/37XSKfZ
Advanced Excel Tricks https://bit.ly/3CGCm3M
Excel Formulas Made Easy http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel http://bit.ly/2Siivkm
Connect with us!
Take the opportunity to connect and share this video with your friends and family if you find it useful.