Easy to do but cannot remember how!
"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.
Ok I just figured it and answered my own question!
The formula is SUM=(A$1), Then higliht that cell and drag down
|