Excel SUMPRODUCT Function - A Guide to a Powerful Excel Function
102.9 هزار بار بازدید -
8 سال پیش
-
A definitive guide to the
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;
www.computergaga.com/
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► www.linkedin.com/company/18737946/
Instagram ► www.instagram.com/computergaga1/
Twitter ► www.twitter.com/computergaga1
8 سال پیش
در تاریخ 1395/04/03 منتشر شده
است.
102,988
بـار بازدید شده