Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/36950

From BetaArchive Wiki
Knowledge Base

Keeping a Cumulative Total in a Column or Row

Article ID: 36950

Article Last Modified on 11/16/2006


  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh

This article was previously published under Q36950


In Microsoft Excel, you can calculate a cumulative total in a column or row of cells by using a combination of absolute and relative references in a SUM() formula.

For example, to keep a running total of cells A1 through A10 in column B (for example, B1 contains the value from A1, B2 contains A1+A2, B3 contains A1+A2+A3, etc.), set up the worksheet as follows:

  1. Type the formula, =SUM($A$1:A1), in cell B1.
  2. Select cells B1 through B10.
  3. On the Edit menu, click Fill Down.

The $A$1 (absolute reference) is constant in each cell, but the A1 (relative reference) is updated in each successive cell to refer to the adjacent cell in column A.

NOTE: This information also applies to the AVERAGE() formula.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.20 3.0 3.00 4.0 4.00 97 98 XL2001 XL98 XL97 XL7 XL5 XL4 XL3 XL2 XL

Keywords: kbhowto KB36950