Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.

The best new tool from Microsoft Excel is undoubtedly the SCAN function. Here's how to use it to calculate running totals. Find the full guide at Spreadsheet Point.