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:
- Type the formula, =SUM($A$1:A1), in cell B1.
- Select cells B1 through B10.
- 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