Microsoft Excel how-to video about Running Totals in Excel.
In one of my Bing Shorts, I showed two different ways to do Running Totals in Excel.
And then, an interesting comment from Carlo in Italy with a running total formula that I’ve never seen before.

To download the data from today, go here: https://www.mrexcel.com/youtube/TnkyqfGGV9g/

I had to bring that formula to Excel to visualize how it was working. It was cool that it used a colon next to INDEX. But is there a simpler way?

In the video, I then compare four different Running Total Formulas. Which are easiest to enter? Which are easiest to explain? Which run the fastest? Thanks to Zack Barresse for teaching me how =SUM(Number,Text) ignore Text without giving an error. Thanks to Charles Williams for the Formula Speed whitepaper and for the Fast Excel tool to measure the speed of the formulas.

You will also catch a Nancy Faust preview of the Spinning Wheel song to entertain you while we wait for the slow versions to calculate.

Table of Contents
(0:00) Running Totals in Excel
(0:14) Bing Shorts explanation
(0:31) Formula from Carlo
(1:08) 8 Functions change when colon-adjacent
(1:40) Why not shorten INDEX?
(2:06) =Up plus =Left with two formulas
(2:45) Zack Barresse and SUM(Up,Left)
(3:15) MrExcel way with expanding range
(4:15) Judging criteria for best running total
(4:45) Charles Williams fastest Running Total
(5:07) Simple formula: less than a second
(5:24) Expanding range: 26.3 seconds
(5:44) Carlo 36.4 seconds
(5:58) Why the simple formula is faster
(6:39) =SUM(Left,Up) is winner
(7:18) Wrap-up