Running Total Formula in Excel Using SUM or SCAN | Year to Date (YTD) Calculations in a Table

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I demonstrate how to create a running totals or year to date formula. The video covers three different methods. The first method uses the SUM function. The second method uses the SCAN function, which is available to Excel 365 users. The third method works in an Excel table and uses the SUM and INDEX functions.

Credit Chester Tugwell