Excel SUMPRODUCT Function - A Guide to a Powerful Excel Function

A definitive guide to the SUMPRODUCT function in Excel. This function is a hidden gem that always surprises users when they see it. 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; https://www.computergaga.com *** 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