| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy to do but cannot remember how!
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy Sumproduct or Sumif - but I can't remember how ..lol ! | Excel Worksheet Functions | |||
| I know this is easy but I don't remember how. | Excel Discussion (Misc queries) | |||
| I used to be able to do this, I can't remember how | Excel Discussion (Misc queries) | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Remember and add | New Users to Excel | |||
Linear Mode
