Skip to main content


Showing posts from September, 2011

Running Totals in Excel

Excel does not have a running total feature or function built in.  All the examples I found on the web to do running totals included VBA code. Not that I have anything against VBA but I thought there should be a way to do running totals with built in worksheet functions. Enter our one of our favorite functions: OFFSET().  But first, what is a running total? A running total is when you have a list of Values and you want to total of the current Value with the Previous values.   Wikipedia states that a running total is "summation of a sequence of numbers which is updated each time a new number is added to the sequence, simply by adding the value of the new number to the running total." The key to getting the SUM() correct is getting the Range correct.  For a given Range of Values, start with the First number and SUM() until you get to the current row.  You can do this by using the OFFSET() function and taking advantage of Excel's table features to get the column range. [vb]