Loading...

Master Excel's SUMPRODUCT Formula

62,420 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 13, 2016

Quickly learn how Excel's SUMPRODUCT formulas works.
Download the workbook: http://www.xelplus.com/excel-sumprodu...

Get the full course: http://www.xelplus.com/onlineAdvanced...

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 ➹ ➹ ➹

Excel VBA & Macros ► http://bit.ly/LeilaVBA
Excel Dashboards ► http://bit.ly/LeilaDashboards
Excel Charts ► http://bit.ly/LeilaCharts
Advanced Excel ► http://bit.ly/LeilaAdvancedExcel
Excel Waterfall Charts ► http://bit.ly/LeilaWaterfall

🕮 Recommend Excel Resources 🕮
https://www.xelplus.com/resources/

✉ Subscribe & get my Excel top 10 tips and formulas e-book for free ✉
https://www.xelplus.com/free-ebook/

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...