★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy'>https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/'>https://exceloffthegrid.com/insiders...
File Reference for this video: 0231 Running total by row.zip

★ About this video ★
Some scenarios in Excel seem easy. However, one small change can lead to the wrong result.

In this video, we are looking at one of those scenarios. It starts out as a simple running total and ends up as an advanced function used LET, MAKEARRAY, LAMBDA, SUM, FILTER.

INCLUDES:
0:00 Introduction
0:18 Scenario
0:42 Basic solution
1:42 Problem with the basic solution
2:10 Calculating position
3:29 SUMIFS alternative
4:46 Understanding MAKEARRAY
5:52 Using MAKEARRAY
6:34 Using LET to simplify the formula
9:29 Calculate by column
9:50 Wrapup

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel