playlistduration

Excel COUNTIF Function Formula Tricks

by excelisfun · 67 videos

Total watch time

9h 20m

at 1× speed · exactly 9 hours, 19 minutes, 33 seconds at 1×

1×9h 19m 33s
1.25×7h 27m 38s
1.5×6h 13m 2s
1.75×5h 19m 45s
2×4h 39m 47s
Average video8m 21s
Longest29m 53s
Shortest1m 39s
Compare Open on YouTube JSON

Plan to finish

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

Videos (67)

9h 20m 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 #180: COUNTIF function formula 21 Examples of Different Criteria 9:42 2009-01-03
2 Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast 7:17 2009-02-24
3 Excel Magic Trick 362: 12 Amazing Counting Formulas 16:45 2009-08-13
4 Excel Name Trick #6: Names COUNTIF & wildcards 6:56 2008-06-13
5 Excel Magic Trick # 269: COUNTIF & Ampersand 2:50 2009-03-02
6 YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid 3:09 2008-06-27
7 YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function 2:30 2008-07-14
8 Excel Magic Trick # 266: Count Words Only w COUNTIF ?* 4:14 2009-02-23
9 Excel Magic Trick #198: 3 Formulas For Frequency Distribution 6:22 2009-01-09
10 Excel Magic Trick #175: Count Between Upper & Lower Value 6:39 2009-01-02
11 Excel Magic Trick #115: Find 2nd Positive Number 2:41 2008-10-10
12 YTLE#95: Complex Advanced Filter Extract 10:07 2008-08-12
13 Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions 7:27 2008-07-28
14 Excel Statistics 27: Dot Plot Chart w REPT & COUNTIF functions 8:58 2008-07-28
15 Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas 10:04 2008-07-25
16 Excel Statistics 19: Grouping Categories w Formula & Pivot Table 6:35 2008-07-25
17 Excel Statistics 12: Categorical Frequency Distribution w Formulas 10:36 2008-07-25
18 YTLE#54: Excel Advanced Filter and COUNTIF function 3:09 2008-07-14
19 YTLE#53: Excel Pivot Table and COUNTIF function 3:26 2008-07-14
20 Excel Name Trick #5: Names for Pivot Tables & more... 6:54 2008-06-13
21 YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF 8:17 2008-04-17
22 Excel Magic Trick #131: Ranking w MIN IF OFFSET 8:49 2008-10-17
23 Excel Magic Trick #148: Dynamic List from Table #3 10:32 2008-11-19
24 Excel Magic Trick #187: Unique List w Dynamic Formula 9:41 2009-01-09
25 Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria 11:05 2009-01-09
26 Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria 10:12 2009-01-09
27 Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria 10:21 2008-12-02
28 Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax 8:21 2010-04-16
29 Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas 5:45 2010-06-22
30 Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together 5:00 2010-09-27
31 Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data 5:47 2011-03-05
32 Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook 7:55 2011-05-16
33 Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria 8:58 2011-05-21
34 Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets 9:43 2011-05-21
35 Excel Magic Trick 803: COUNTIF Function Criteria & Comparative Operator Trouble & ASCII Characters 5:27 2011-09-16
36 Excel Magic Trick 830: No Duplicates Allowed In Row, Data Validation Custom Logic Formula COUNTIF 4:26 2011-12-04
37 Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns 16:06 2011-12-07
38 Excel Magic Trick 842: Is Item A Duplicate In Column? Excluding First Occurrence: COUNTIF 2:26 2011-12-15
39 Excel Magic Trick 843: Is Record Duplicate, Excluding First Occurrence? COUNTIFS Function 4:54 2011-12-15
40 Excel Magic Trick 854: COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column 1:39 2012-01-13
41 Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format 5:06 2012-05-23
42 Excel Magic Trick 1369: COUNTIFS To Count Not Empty Cells With 4 Criteria/Conditions 9:42 2017-01-09
43 Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? 29:29 2017-02-11
44 Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples) 27:03 2017-09-28
45 Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special" 4:53 2018-02-17
46 Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special" 8:11 2018-02-19
47 Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special" 8:11 2018-02-19
48 Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price 7:51 2018-03-22
49 Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples 14:36 2018-08-10
50 Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula? 5:26 2018-08-25
51 Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533 15:38 2018-12-23
52 E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays? 29:53 2019-02-24
53 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
54 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
55 4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too 6:50 2019-07-16
56 OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573 4:40 2019-07-24
57 INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574 2:52 2019-07-24
58 Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603 3:13 2019-09-18
59 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
60 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764 10:14 2021-11-01
61 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777 10:51 2022-03-07
62 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
63 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
64 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
65 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
66 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
67 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850 3:02 2024-01-23

Embed a badge

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

Watch time: 9h 20m · 67 videos

Markdown
[![Watch time: 9h 20m · 67 videos](https://playlistduration.com/badge/playlist/PLCC43000DF049CD6A.svg)](https://playlistduration.com/playlist/PLCC43000DF049CD6A)
HTML
<a href="https://playlistduration.com/playlist/PLCC43000DF049CD6A"><img src="https://playlistduration.com/badge/playlist/PLCC43000DF049CD6A.svg" alt="Watch time: 9h 20m · 67 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/PLCC43000DF049CD6A 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.