Easy to do but cannot remember how!
=SUM($A$1:A2) entered in B2 and copied down
In B1 just enter =A1 or =$A$1 but don't copy that.
Gord Dibben MS Excel MVP
On Thu, 10 Jul 2008 10:21:08 -0700, Chivalrous1
wrote:
A B
1 SUM(A1)
2 SUM(A1:A2)
3 SUM(A1:A3)
4
5
6
7
Question is, how do I fill down so that A1 stays as a constant? When I
hightlight and drag it will just add to the A1.
|