playlistduration

Excel Functions & Multiple Criteria Tricks

by excelisfun · 27 videos

Total watch time

3h 17m

at 1× speed · exactly 3 hours, 17 minutes, 12 seconds at 1×

1×3h 17m 12s
1.25×2h 37m 46s
1.5×2h 11m 28s
1.75×1h 52m 41s
2×1h 38m 36s
Average video7m 18s
Longest14m
Shortest2m 36s
Compare Open on YouTube JSON

Plan to finish

About 4 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 4 days. Turn on JavaScript to plan around your week.

Videos (27)

3h 17m in total · tick what you've watched

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

Videos to
Watched
1 YTLE#64: D Function: DAVERAGE DSUM & more 10:11 2008-07-24
2 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
3 Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel 2:36 2008-10-28
4 Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF 5:23 2008-10-28
5 Excel Magic Trick #145 p2 MODE IF 4:40 2008-10-28
6 Excel Magic Trick #168: Cross Tabulation For a Survey 6:27 2008-12-30
7 YTLE#86: Pivot Table Filtering & Functions 5:15 2008-08-07
8 YTLE#111: Excel AVERAGE w Multiple Criteria 4:20 2008-08-30
9 Excel Magic Trick #122: Sum With More Than 1 Criteria 9:17 2008-10-17
10 Excel Magic Trick #121: Count With More Than 1 Criteria Condition 7:35 2008-10-17
11 Excel Basics #20: Data Analysis Pivot Tables PivotTables 10:23 2008-12-16
12 YTLE#91: PivotTable: Average w MONTH criteria 4:59 2008-08-11
13 YTLE#70 PivotTable & TRIM function & AVERAGES 8:32 2008-07-28
14 Excel Statistics 19: Grouping Categories w Formula & Pivot Table 6:35 2008-07-25
15 Excel Magic Trick #130: 3 Dimensional Database in Excel 7:55 2008-10-17
16 Excel Magic Trick 167p2 IF function formula: 12 Examples! 10:34 2008-12-02
17 Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples 14:00 2009-02-24
18 Excel Formula Efficiency 3: Database D Functions Are Fast 9:44 2009-02-24
19 Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast 7:17 2009-02-24
20 Excel Formula Efficiency 6: Concatenated Field Speeds Up Formula 6:43 2009-02-24
21 Excel Magic Trick 344: MAX IF & RANK functions without Zeros 6:31 2009-07-24
22 Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas 5:45 2010-06-22
23 Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken 6:26 2011-03-14
24 Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions 7:15 2011-09-27
25 Excel Magic Trick 833: AVERAGEIFS function & Wildcards, Averaging With Multiple Conditions Criteria 3:37 2011-12-07
26 Mr Excel & excelisfun Trick 142: AVERAGE IF Before Excel 2003, Average with 1 Condition 8:45 2013-10-04
27 Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks 13:28 2018-07-25

Embed a badge

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

Watch time: 3h 17m · 27 videos

Markdown
[![Watch time: 3h 17m · 27 videos](https://playlistduration.com/badge/playlist/PL4FCBB029391A320D.svg)](https://playlistduration.com/playlist/PL4FCBB029391A320D)
HTML
<a href="https://playlistduration.com/playlist/PL4FCBB029391A320D"><img src="https://playlistduration.com/badge/playlist/PL4FCBB029391A320D.svg" alt="Watch time: 3h 17m · 27 videos" width="203" 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/PL4FCBB029391A320D 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.