Premium Only Content
![Master Excel's SUMPRODUCT Formula](https://1a-1791.com/video/s8/1/2/w/f/d/2wfdk.qR4e-small-Master-Excels-SUMPRODUCT-Fo.jpg)
Master Excel's SUMPRODUCT Formula
Apr 13, 2016 Excel Advanced Formulas & Features
Quickly learn how Excel's SUMPRODUCT formulas works.
Download the workbook: http://www.xelplus.com/excel-sumproduct-formula-easy-explanation/
Get the full course: https://courses.xelplus.com
Advanced Excel: Master Excel's SUMPRODUCT Formula
This video is part of a series that belongs to my Advanced Training course called "Advanced Excel: Top tips and formulas".
The classical use of Excel's SUMPRODUCT function is to do a sum of multiplications. The good thing about SUMPRODUCT is that it can work on arrays of values and it doesn’t have to be entered as an array function so no need to do control + shift + enter (CSE).
The great thing about SUMPRODUCT, is that it can help solve many more problems in non-obvious ways. It can act as a conditional SUMIFS function or work as a lookup function as INDEX and MATCH does. It can also act as a COUNTIF function.
SUMPRODUCT is also a better SUMIFS, because it can check for OR conditions - which the SUMIFS can't. SUMIFS can only check for AND conditions.
In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you from unnecessary "workarounds" in your Excel files. It will also show you the SUMPRODUCT formula in slow motion.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:01:13
Candace Show Podcast
3 hours agoBlake Lively's BOMBSHELL Legal Filing | Candace Ep 149
41.6K42 -
1:41:00
Darkhorse Podcast
4 hours agoIf Only We’d Known: The 265th Evolutionary Lens with Bret Weinstein and Heather Heying
44.5K23 -
1:11:22
Vigilant News Network
6 hours agoElon Musk Shuts Down RFK Jr. Critics With One Powerful Statement | The Daily Dose
37.6K6 -
LIVE
Dad Dojo Podcast
18 hours agoEP20: The Super Bowl and Solving The Economy
51 watching -
4:49
Tactical Advisor
3 days agoBest Small Handgun Optics | CH PWS Shot Show 2025
151 -
1:01:21
In The Litter Box w/ Jewels & Catturd
22 hours agoI've Got Your Proof - Right Here! | In the Litter Box w/ Jewels & Catturd – Ep. 745 – 2/19/2025
61.3K23 -
2:14:30
FreshandFit
6 hours agoDavid Icke On COVID Lies, Censorship, Secret Societies, Infiltration of MAGA, AI Control, Alternative Media Subversion And MORE!
70K34 -
1:41:41
The Quartering
8 hours agoTrump's New IVF Order, GameStop CEO Denounces Wokeness Amid Sale, and Elon Musk's DOGE Role Revealed
92.3K54 -
LIVE
Dr Disrespect
6 hours ago🔴LIVE - DR DISRESPECT - TARKOV - ZERO TO HERO PISTOL ONLY
2,349 watching -
1:55:42
Film Threat
8 hours agoCRISIS ON MULTIPLE MARVEL MOVIES! | Hollywood on the Rocks
17.7K