Keeping a Cumulative Total in a Column or Row (36950)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbhowto KB36950 |
|---|
|