Easy to do but cannot remember how!
Two solutions to your question
=sum($a$1:a1) - copy down
but in this case you could also
in B1 =A1
in b2 =B1+A2 - copy down
--
Wag more, bark less
"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.
|