1
Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria
35:16
2017-11-16
2
Excel Magic Trick #121: Count With More Than 1 Criteria Condition
7:35
2008-10-17
3
Excel Magic Trick 362: 12 Amazing Counting Formulas
16:45
2009-08-13
4
Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast
7:17
2009-02-24
5
Excel Array Formula Series #7: Boolean Logic & Criteria
10:05
2008-06-26
6
Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT
4:46
2010-03-12
7
Excel Magic Trick #168: Cross Tabulation For a Survey
6:27
2008-12-30
8
YTLE#64: D Function: DAVERAGE DSUM & more
10:11
2008-07-24
9
Excel Magic Trick 368: Count Unique Items With More Than One Criteria
14:02
2009-08-13
10
YTLE#102: Count Dates given 2 Criteria - Excel
6:04
2008-08-30
11
Excel Magic Trick #198: 3 Formulas For Frequency Distribution
6:22
2009-01-09
12
YTLE#56: Excel Count Unique Values Greater Than $30
10:52
2009-01-06
13
Excel Magic Trick #175: Count Between Upper & Lower Value
6:39
2009-01-02
14
YTLE#54: Excel Advanced Filter and COUNTIF function
3:09
2008-07-14
15
Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples
14:00
2009-02-24
16
Excel Formula Efficiency 3: Database D Functions Are Fast
9:44
2009-02-24
17
Excel Formula Efficiency 6: Concatenated Field Speeds Up Formula
6:43
2009-02-24
18
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice
10:07
2009-08-13
19
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice
10:07
2009-08-13
20
Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product
5:33
2010-02-24
21
Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date
7:34
2010-03-23
22
Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula
10:01
2010-05-11
23
Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function
5:31
2010-05-03
24
Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks
17:40
2010-06-04
25
Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas
5:45
2010-06-22
26
Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Years
2:31
2010-06-22
27
Excel Magic Trick 651: Comparative Operators & Logical Formulas
4:59
2010-07-17
28
Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas
11:34
2010-07-17
29
Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function
3:07
2010-07-17
30
Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format
11:36
2010-07-31
31
Excel Magic Trick 748: Count Weekends With No Events Scheduled Formula
9:55
2010-12-08
32
Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)
36:28
2011-04-19
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 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples
20:20
2011-06-10
36
Excel Magic Trick 908: Count Text Entries Between Two Dates
5:04
2012-04-13
37
Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format
5:06
2012-05-23
38
Excel Magic Trick 982: Add w One Condition, Use SUMIF Instead of SUMPRODUCT or DSUM
8:26
2012-12-25
39
Excel Magic Trick 980: OR and AND Counting Criteria In One Formula, Boolean or MATCH?
8:38
2012-12-15
40
Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function
7:17
2013-09-08
41
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
6:00
2014-04-03
42
Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)
3:46
2014-04-10
43
Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting
8:38
2014-04-11
44
Mr Excel & excelisfun Trick 162 Count Between Upper Lower Time: Data Table COUNTIFS SUMPRODUCT
8:27
2014-08-01
45
Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)
6:11
2014-11-22
46
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
14:14
2015-03-13
47
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
6:57
2015-03-24
48
Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters
4:59
2015-03-25
49
Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?
12:28
2015-05-07
50
Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions
4:07
2015-07-28
51
Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?
7:14
2015-09-13
52
Excel Magic Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT
5:46
2015-12-30
53
Excel Magic Trick 1247: Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT
4:08
2016-01-01
54
Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT
5:16
2016-01-02
55
Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test
4:04
2016-03-20
56
Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)
31:55
2016-09-24
57
Excel Magic Trick 1327: Formula to Count Words in Column with Mixed Data: COUNTIFS Function
4:21
2016-10-07
58
Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)
6:55
2016-10-09
59
Excel Magic Trick 1369: COUNTIFS To Count Not Empty Cells With 4 Criteria/Conditions
9:42
2017-01-09
60
Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country
28:32
2017-03-02
61
Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable?
3:56
2017-03-12
62
Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups
30:33
2017-07-01
63
Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups
7:44
2017-07-02
64
Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups
18:09
2017-07-02
65
Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
27:23
2017-07-06
66
Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month
13:46
2017-08-09
67
Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month
10:30
2017-08-11
68
Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)
27:03
2017-09-28
69
Excel Magic Trick 1472: Count Between (or Above and Below) Upper & Lower Limits (7 Examples)
22:14
2017-12-22
70
Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test
20:12
2018-04-04
71
Excel Magic Trick 1507: Count Empty in Non-Adjacent Cells (5 Examples) AREAS Function?
9:35
2018-06-16
72
Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples
14:36
2018-08-10
73
Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?
5:26
2018-08-25
74
Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533
15:38
2018-12-23
75
E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
29:53
2019-02-24
76
E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
29:53
2019-02-24
77
COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550
3:11
2019-04-22
78
Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613
3:47
2019-10-22
79
Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620
9:32
2019-11-25
80
Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630
2:37
2019-12-27
81
Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.
9:56
2020-04-03
82
Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659
18:33
2020-04-10
83
Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
5:15
2020-12-14
84
Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767
9:49
2021-12-20
85
COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777
10:51
2022-03-07
86
Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808
4:39
2022-12-12
87
Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819
16:06
2023-02-26
88
Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848
5:50
2024-01-29
89
Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849
5:41
2024-02-05
90
Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850
3:02
2024-01-23
91
COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891
6:09
2025-05-03
92
Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898
8:20
2025-06-22
93
COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
24:46
2025-08-15
94
Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902
24:47
2025-08-21
95
Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911
8:45
2025-10-03
