1
Excel Magic Trick #203: SUMIF function formula 21 Examples of Different Criteria
10:50
2009-01-09
2
Highline Excel Class 09: SUMIF Function Formula 3 Examples
9:19
2009-04-01
3
Excel Dynamic Chart #7: SUMIFS function
6:37
2009-12-11
4
SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978
1:09:15
2012-11-29
5
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays
10:22
2009-05-01
6
Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF
9:25
2009-05-09
7
Excel Magic Trick 411: Expandable Ranges In SUMIFS function.
4:38
2009-10-14
8
Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods
10:29
2009-11-19
9
Excel Magic Trick 443: SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table
4:50
2009-11-16
10
Excel Magic Trick 553: SUMIF for Dollars and Euros
4:03
2010-03-23
11
Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax
8:21
2010-04-16
12
Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard
4:54
2010-06-04
13
Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas
7:32
2010-06-04
14
Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas
5:45
2010-06-22
15
Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Table
13:26
2010-07-06
16
Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work
3:01
2010-08-06
17
Excel Magic Trick 730: SUMIF with Approximate Criteria
3:20
2010-09-27
18
Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function
2:44
2010-12-08
19
Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook
7:55
2011-05-16
20
Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria
8:58
2011-05-21
21
Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets
9:43
2011-05-21
22
Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns
16:06
2011-12-07
23
Excel Magic Trick 837: Lookup Multiplying with SUMIF & PRODUCT Experimental Outcome Probability
3:41
2011-12-15
24
Excel Magic Trick 857: SUMIF Function with Sheet References: Summarize Data From Different Sheet
3:15
2012-01-15
25
Mr Excel & excelisfun Trick 126: SUM Daily Totals from Text Dates with Text Day Criteria
8:01
2013-05-30
26
Excel Magic Trick 1055: Grading: Calculate Current Percentage & Decimal Grade
9:19
2013-09-27
27
Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set
6:51
2014-01-09
28
Excel Magic Trick 1368: How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region
7:54
2017-01-05
29
Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)
55:04
2017-01-31
30
Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?
29:29
2017-02-11
31
Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
16:33
2017-03-16
32
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
19:28
2017-03-23
33
Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report
13:34
2017-04-15
34
Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
5:26
2017-04-15
35
Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center
6:46
2018-10-08
36
Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518
7:44
2018-10-23
37
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520
9:16
2018-10-24
38
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528
13:02
2018-10-28
39
Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue
4:39
2019-01-18
40
Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS
7:09
2019-02-14
41
E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
29:53
2019-02-24
42
MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
6:17
2019-05-23
43
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
13:38
2019-05-31
44
Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553
31:16
2019-06-07
45
MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
10:20
2019-06-11
46
Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555
3:32
2019-07-01
47
Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change
3:27
2019-07-05
48
4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too
6:50
2019-07-16
49
Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604
3:29
2019-09-19
50
Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632)
4:03
2020-01-07
51
Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651
4:17
2020-03-23
52
Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652
5:42
2020-03-24
53
Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
6:08
2020-05-16
54
SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671
7:28
2020-06-08
55
LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673
7:01
2020-06-22
56
LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.
14:32
2020-08-03
57
Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
5:15
2020-12-14
58
Private video
—
59
SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739
5:56
2021-06-08
60
Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740
11:18
2021-06-14
61
Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
11:38
2021-06-29
62
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
10:33
2021-07-06
63
IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
9:05
2021-07-28
64
Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
10:14
2021-11-01
65
COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777
10:51
2022-03-07
66
HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780
5:34
2022-03-16
67
HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781
11:30
2022-03-18
68
Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787
18:07
2022-03-28
69
Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802
3:28
2022-10-30
70
Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836
5:42
2023-08-27
71
Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854
3:23
2024-02-26
