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