Excel Magic Trick 406: Add 1 Extra For Each Deposit
Loading...
Loading...
14:06
Excel Magic Trick 407: Amortization Table W Variable Rateby ExcelIsFun7,667 views- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun36,357 views
- 7:22
Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Downby ExcelIsFun9,439 views
- 5:43
Excel Statistics 29: Quantitative Cross Tabulation W Pivot Tableby ExcelIsFun8,083 views
- 4:13
Excel Magic Trick 412: Data Validation Drop Down List & OFFSET functionby ExcelIsFun6,095 views
- 3:52
Excel Magic Trick 402: Monthly Comparative Report - Pivot Tableby ExcelIsFun5,428 views
- 4:41
Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT functionby ExcelIsFun1,347 views
- 3:53
Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Functionby ExcelIsFun6,170 views
- 5:02
Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELLby ExcelIsFun4,112 views
- 0:52
The Hellmouthby SolaceDream806 views
- 2:49
Excel Magic Trick 387: Data Validation Drop-Down List & Cell Referencesby ExcelIsFun6,117 views
- 4:36
Excel Magic Trick 463: 4 ways to Add New Data To A Chartby ExcelIsFun2,234 views
- 2:41
Excel Magic Trick 399: NA Error Trouble in Array Formulaby ExcelIsFun1,830 views
- 4:23
Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Valueby ExcelIsFun2,791 views
- 3:04
Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculationsby ExcelIsFun8,311 views
- 2:21
Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cellsby ExcelIsFun3,309 views
- 1:55
Excel Magic Trick 391: Custom Number Format to Insert Symbol Automaticallyby ExcelIsFun2,866 views
- 3:28
Excel Magic Trick 432: Find & Extract Duplicate Recordsby ExcelIsFun6,064 views
- 1:30
Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculationby ExcelIsFun1,851 views
- 3:26
Excel Magic Trick 390: Increment Word & Number 2 Methods.by ExcelIsFun2,953 views
Thnaks for letting me know! I will post the correct workbook tomorrow. The formula in the video is much better than the one in the downloaded workbook.
ExcelIsFun 2 years ago
Mike, EMT406 displays an array formula versus sum + count you describe in the video.
krn14242 2 years ago
The funny thing is that when I first came up with an answer, I did a complicted array formula and then I went, Duh.
SUM + COUNT
ExcelIsFun 2 years ago
Ooh, that's a very interesting one :D. Seems simple enough too, I thought this would be massively complicated like the OFFSET function, but it seems really easy.
Mynotoar 2 years ago