REDUCE: How to Build Running Calculations Across Any Dimension in Excel
REDUCE is the most powerful of the functional array functions and the most overlooked. The lambda which means you can accumulate strings, and replace calculations that used to need VBA.