Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/YTD.xlsx

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.

#microsoftexcel

00:00 Introduction
00:25 Method 1: Use the SUM Function
02:51 Method 2: Use the SCAN function
05:45 Method 3: Use SUM and INDEX (In Tables)