# Microsoft KB Archive/36950

 Knowledge Base

# Keeping a Cumulative Total in a Column or Row

Article ID: 36950

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

## 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