Download Excel File: https://excelisfun.net/files/EMT1769.xlsx
Learn Accounting and Financial Spilled Array Formulas when the formula uses a Relative Cell Reference, One Cell Above, as an Accumulator like in investment value from period to period (multiplicative) or a checkbook balance from period to period (additive) using the SCAN and LAMBDA functions.

1. (00:00) Introduction
2. (00:42) Old School Excel Formula with Relative Cell Reference, One Cell Above, to calculate an investment value in each row
3. (01:10) SCAN and LAMBDA to calculate a running balance for an investment account in a multiplicative process.
4. (03:38) Old School Excel Formula with Relative Cell Reference, One Cell Above, to calculate a checkbook balance in each row
5. (04:06) SCAN and LAMBDA to calculate a running balance for a checkbook account in an additive process
6. (04:46) Summary
7. (05:05) Closing and Video Links