Excel SUMPRODUCT Function – A Guide to a Powerful Excel Function

Channel Avatar
Comment
X
Share
Excel SUMPRODUCT Function - A Guide to a Powerful Excel Function
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
Creating Sports League Tables and Tournaments in Excel http://bit.ly/2Siivkm

Connect with us!

LinkedIn https://www.linkedin.com/company/18737946/
Instagram https://www.instagram.com/computergaga1/
Twitter http://www.twitter.com/computergaga1

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *