Keeping a Cumulative Total in a Column or Row

View products that this article applies to.

Article ID	:	36950
Last Review	:	November 16, 2006
Revision	:	1.4

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:

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.

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

Back to the top

	17.376.869	Kostenlose Z�hler
In memoriam C-BIT Information-Center Hannover (2.241/1075+2.241/1076 - no longer active)
Free webspace
Sicherheitshinweis: Wir weisen vorsorglich darauf hin, dass wir bei der Anmeldung saemtliche automatisch uebermittelten Parameter wie IP-Adresse und/oder Einwahlrufnummer speichern, um uns und unsere Kunden vor Missbrauch zu schuetzen. Selbstverstaendlich werden wir bei Bedarf umgehend strafrechtliche Massnahmen ergreifen, um einen vorliegenden Missbrauch zu ahnden.