In Microsoft Excel 2000, 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.
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; and so on), follow these steps:
- Start Excel and open a new workbook.
- In cell B1 type the following formula:
- Select cells B1 through B10.
- On the Edit menu, point to Fill, and then click Down.
The $A$1 (absolute reference) is constant in each cell, although the A1
(relative reference) is updated in each successive cell to refer to the adjacent cell in column A.
- Type the following data into the worksheet:
- The cells in column B return the following data:
: To calculate a running average of the numbers in column A, replace SUM with AVERAGE in the formulas.
Article ID: 214149 - Last Review: September 27, 2003 - Revision: 3.1
- Microsoft Excel 2000 Standard Edition