Microsoft KB Archive/36950

= Keeping a Cumulative Total in a Column or Row =

Article ID: 36950

Article Last Modified on 11/16/2006

-

APPLIES TO


 * 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





SUMMARY
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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.