1. ## adding cells in a column (2003)

Hi,
I am trying to figure out how to calculate for each cell A j in a column range the sum of all the cells in the range up to that one.
So, if the input range is A1 - A100, the output range is ,say, B1 to B100 with B1 = A1 and Bj =sum( A 1: A j ).

Thanks so much for your help,
Cosmin

2. ## Re: adding cells in a column (2003)

Welcome to Woody's Lounge!

Enter the following formula in B1:

=SUM(\$A\$1:\$A1)

and fill down to B100 (for example by double clicking the fill handle in the lower right corner of B1). \$ characters make a cell reference absolute, i.e. it won't be changed when filling down. In the formula, \$A\$1 is absolute, so it will remain the same; in \$A1 the row number is relative (not absolute), so it will be adjusted when filling down.

3. ## Re: adding cells in a column (2003)

thank you !
I spent two days already trying to figure it out myself.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•