playlistduration

Excel SUMPRODUCT Function Playlist of Videos

by excelisfun · 79 videos

Total watch time

11h 29m

at 1× speed · exactly 11 hours, 29 minutes, 19 seconds at 1×

1×11h 29m 19s
1.25×9h 11m 27s
1.5×7h 39m 33s
1.75×6h 33m 54s
2×5h 44m 40s
Average video8m 44s
Longest45m 17s
Shortest1m 30s
Compare Open on YouTube JSON

Plan to finish

About 12 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 12 days. Turn on JavaScript to plan around your week.

Videos (79)

11h 29m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples) 36:28 2011-04-19
2 Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE 9:12 2011-04-22
3 Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook 7:55 2011-05-16
4 Ctrl + Shift + Enter: Excel Array Formulas 09: SUMPRODUCT Function: 21 Examples, Including Timing 45:17 2014-01-16
5 Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows 12:42 2013-07-08
6 Highline Excel Class 37: SUMPRODUCT function 20:00 2009-05-13
7 Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples 14:00 2009-02-24
8 Excel Magic Trick 457: SUMPRODUCT & OR Criteria 5:27 2009-11-30
9 Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work 3:01 2010-08-06
10 Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Instead 4:57 2010-09-17
11 Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function 2:44 2010-12-08
12 ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock 11:44 2010-11-30
13 ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio 10:48 2010-11-30
14 Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add 5:32 2010-11-16
15 Mr Excel & excelisfun Trick 55: Calculate Grade & Exclude Scores When Student Is Absent. 5:36 2010-11-11
16 Excel Magic Trick 733: Expected Returns For Portfolio SUMPRODUCT & MMULT functions 9:00 2010-10-14
17 Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF 3:23 2010-09-03
18 Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples) 8:13 2010-09-03
19 Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT 5:57 2010-09-03
20 Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution 7:18 2010-09-03
21 Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!! 11:12 2010-07-28
22 Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF 6:09 2010-07-28
23 Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods) 18:17 2010-06-22
24 Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Years 2:31 2010-06-22
25 Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas 7:32 2010-06-04
26 Excel Magic Trick 611: Array Formula Year Over Year Sales Calculation From Daily Transactional Data 6:25 2010-05-27
27 Excel Magic Trick 613: Array Formula Year Over Year Sales Calculation From Dates Listed As Text 7:44 2010-05-27
28 Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula 10:01 2010-05-11
29 Excel Magic Trick 596: Counting With 4 Criteria Including All Criteria As A Possibility 6:45 2010-05-07
30 Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics 13:24 2010-05-03
31 Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function 5:31 2010-05-03
32 Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records 6:28 2010-04-23
33 Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT 4:46 2010-03-12
34 Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL 5:57 2010-03-02
35 Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product 5:33 2010-02-24
36 Excel Magic Trick 497: Unit Inventory Total For Each Store SUMIFS or SUMPRODUCT functions 10:52 2010-02-05
37 Excel Magic Trick 491: Count Matches in Individual Cells 2:28 2010-02-02
38 Excel Magic Trick 492: Count Matches in Single Cell 7:01 2010-02-02
39 Mr Excel & Excelisfun Trick43: End Inventory Value From Transactional Records SUMPRODUCT SUMIF 6:44 2010-01-15
40 Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data 4:52 2010-01-08
41 Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation 1:30 2010-01-08
42 Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions 5:49 2010-01-01
43 Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format) 3:55 2010-01-01
44 Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT 5:53 2009-12-18
45 Excel Dynamic Chart #8: SUMPRODUCT function (Excel 2003 substitute for SUMIFS) 2:11 2009-12-11
46 Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function 4:41 2009-10-08
47 Excel Magic Trick 377: Add Every Other Number In Range of Cells 4:30 2009-09-04
48 Excel Magic Trick 374: COUNT Odd or Even Numbers 5:54 2009-09-03
49 Excel Magic Trick 362: 12 Amazing Counting Formulas 16:45 2009-08-13
50 Excel Magic Trick 366: Lookup Adding For Accounting Estimate 3:15 2009-08-13
51 Excel Magic Trick 354: 2 Criteria Counting for Blood Sugar Levels 8:57 2009-08-07
52 Excel Statistics 60: Budget Income Statement (Probability) SUMPRODUCT function 6:41 2009-07-13
53 Excel Statistics 59: Discrete Probability Mean & Standard Deviation SUMPRODUCT function 19:40 2009-07-13
54 Excel Statistics 55.5: Bayes Theorem Posterior Probabilities 5:26 2009-07-13
55 Excel Magic Trick 339: Sum Differences with 2 Criteria SUMPRODUCT 3:23 2009-06-22
56 Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions 4:46 2009-06-03
57 Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria 8:58 2011-05-21
58 Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function 11:16 2011-09-27
59 Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns 16:06 2011-12-07
60 Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows 12:42 2013-07-08
61 Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho 5:55 2013-07-13
62 Excel Magic Trick 1036: SUM Rectangular Table, 1 condition Row Headers & Or Criteria Column Headers 6:02 2013-08-05
63 Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column) 7:57 2014-03-13
64 Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) 6:11 2014-11-22
65 Excel Magic Trick 1171: SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead 3:06 2015-01-15
66 Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Example 11:49 2015-01-24
67 Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score 6:24 2016-03-18
68 Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test 4:04 2016-03-20
69 Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples) 27:03 2017-09-28
70 Mr Excel & excelisfun Trick 187: SUMIFS to add only Filtered Columns, NOT Hidden Rows 12:25 2017-10-27
71 MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships 13:38 2019-05-31
72 Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604 3:29 2019-09-19
73 Sum Last Digits for All Numbers - Excel Magic Trick 1605 3:27 2019-09-20
74 Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609 6:08 2019-09-29
75 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
76 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
77 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
78 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
79 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 11h 29m · 79 videos

Markdown
[![Watch time: 11h 29m · 79 videos](https://playlistduration.com/badge/playlist/PLDA6FDE9D810EB60B.svg)](https://playlistduration.com/playlist/PLDA6FDE9D810EB60B)
HTML
<a href="https://playlistduration.com/playlist/PLDA6FDE9D810EB60B"><img src="https://playlistduration.com/badge/playlist/PLDA6FDE9D810EB60B.svg" alt="Watch time: 11h 29m · 79 videos" width="210" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLDA6FDE9D810EB60B returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.