View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chivalrous1 Chivalrous1 is offline
external usenet poster
 
Posts: 2
Default 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