1
Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria
35:16
2017-11-16
2
SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978
1:09:15
2012-11-29
3
Excel Magic Trick #122: Sum With More Than 1 Criteria
9:17
2008-10-17
4
You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS
8:09
2008-04-17
5
Excel Array Formula Series #7: Boolean Logic & Criteria
10:05
2008-06-26
6
YTLE#64: D Function: DAVERAGE DSUM & more
10:11
2008-07-24
7
Excel Basics #20: Data Analysis Pivot Tables PivotTables
10:23
2008-12-16
8
Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria
11:34
2009-01-28
9
Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples
14:00
2009-02-24
10
Excel Formula Efficiency 3: Database D Functions Are Fast
9:44
2009-02-24
11
Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast
7:17
2009-02-24
12
Excel Formula Efficiency 6: Concatenated Field Speeds Up Formula
6:43
2009-02-24
13
Excel Magic Trick 297.5: Conditional Sum for Varying Columns
7:25
2009-03-23
14
Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record
10:13
2009-10-14
15
Excel Magic Trick 411: Expandable Ranges In SUMIFS function.
4:38
2009-10-14
16
Excel Magic Trick 497: Unit Inventory Total For Each Store SUMIFS or SUMPRODUCT functions
10:52
2010-02-05
17
Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas
7:32
2010-06-04
18
Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas
5:45
2010-06-22
19
Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Table
13:26
2010-07-06
20
Excel Magic Trick 651: Comparative Operators & Logical Formulas
4:59
2010-07-17
21
Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas
11:34
2010-07-17
22
Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function
3:07
2010-07-17
23
Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format
11:36
2010-07-31
24
Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets
14:32
2010-12-26
25
Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?
8:09
2010-12-28
26
Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria
5:48
2011-03-15
27
Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)
36:28
2011-04-19
28
Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria
8:58
2011-05-21
29
Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets
9:43
2011-05-21
30
Excel Magic Trick 788: Add Numbers After Last Zero
11:25
2011-06-06
31
Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples
20:20
2011-06-10
32
Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function
11:16
2011-09-27
33
Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract Unique Records & Adding W Criteria
6:21
2011-09-27
34
Excel Magic Trick 851: Formula To Sum Unique Values In Column
12:04
2012-01-05
35
Excel Magic Trick 876: Summarize GL Accounts Specific Date Period From Different Workbook
6:15
2012-03-06
36
Excel Magic Trick 892: Add Numbers Between 2 Dates w Multiple Criteria from Multiple Workbooks
6:49
2012-03-30
37
Excel Magic Trick 891: Dynamic Subtotals Using Table Feature and SUMIF or SUMIFS functions
2:55
2012-03-30
38
Excel Magic Trick 910: Adding with AND, BETWEEN and OR Criteria: SUMIFS and COUNTIF Functions
5:23
2012-04-24
39
Mr Excel & excelisfun Trick 121: MIN and MAX Between Two Dates For Each Region
9:12
2013-04-26
40
Excel Magic Trick 997: Add Daily Sales with Text Day Criteria: 3 or 4 Day Abbreviation Convention
11:36
2013-05-31
41
Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range
10:26
2013-07-23
42
Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set
7:23
2014-01-04
43
Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set
6:51
2014-01-09
44
Excel Magic Trick 1083: SUMIFS: Add Invoice Amounts Between Start & End Dates (Adding For Period)
3:46
2014-03-13
45
Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)
7:57
2014-03-13
46
Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting
8:38
2014-04-11
47
Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch
14:22
2014-05-01
48
Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions
4:07
2015-07-28
49
Excel Magic Trick 1237: Add with "Contains Criteria" or Partial Text Criteria: SUMIFS & Wildcard
3:56
2015-09-15
50
Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)
6:55
2016-10-09
51
Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)?
12:33
2016-10-12
52
Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more…
14:14
2016-10-25
53
Excel Magic Trick 1342: Adding Column That Contains Errors SUMIF or AGGREGATE?
7:20
2016-11-10
54
Excel Magic Trick 1368: How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region
7:54
2017-01-05
55
Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)
55:04
2017-01-31
56
Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?
29:29
2017-02-11
57
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
19:28
2017-03-23
58
Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
12:47
2017-03-26
59
Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report
13:34
2017-04-15
60
Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
5:26
2017-04-15
61
Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
6:07
2017-05-29
62
Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total
6:52
2017-05-30
63
Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total
6:52
2017-05-30
64
Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function
16:16
2017-05-31
65
Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function
10:35
2017-08-15
66
Excel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT
7:09
2017-08-30
67
Mr Excel & excelisfun Trick 187: SUMIFS to add only Filtered Columns, NOT Hidden Rows
12:25
2017-10-27
68
Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)
37:16
2017-12-13
69
Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)
8:42
2018-02-04
70
Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue
4:39
2019-01-18
71
Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS
7:09
2019-02-14
72
Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS
7:09
2019-02-14
73
E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
29:53
2019-02-24
74
MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
6:17
2019-05-23
75
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
13:38
2019-05-31
76
MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
10:20
2019-06-11
77
Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
6:08
2020-05-16
78
SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671
7:28
2020-06-08
79
LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673
7:01
2020-06-22
80
Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
5:15
2020-12-14
81
Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
4:27
2021-02-15
82
Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725
15:43
2021-02-18
83
Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740
11:18
2021-06-14
84
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
10:33
2021-07-06
85
IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
9:05
2021-07-28
86
Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
10:14
2021-11-01
87
COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777
10:51
2022-03-07
88
Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911
8:45
2025-10-03
