Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a formula
I want to copy a formula down a column but not change the first value.
Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a formula
"Laundone" wrote in message
... I want to copy a formula down a column but not change the first value. Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks You need to use an absolute reference i.e. $AV$4:$BU$4. V |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a formula
Hi,
The $ sign locks the address and there are 4 variations. the formula below shows all 4 =SUMIF(AV4:$BU$4,"child",$AV7:B$U7) AV4= releative both change when dragged $B$4 = absolute i.e nothing changes when dragged $AV7 = Column will not change but row will B$U7 =Row will not change but column will Mike "Laundone" wrote: I want to copy a formula down a column but not change the first value. Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a formula
Just to add...
When you type in your cell reference in a formula and are still in the edit mode, hit F4, it will toggle the cell through the four references available to the cell as Mike points out. HTH Regards, Howard "Laundone" wrote in message ... I want to copy a formula down a column but not change the first value. Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a formula
thanks
"L. Howard Kittle" wrote: Just to add... When you type in your cell reference in a formula and are still in the edit mode, hit F4, it will toggle the cell through the four references available to the cell as Mike points out. HTH Regards, Howard "Laundone" wrote in message ... I want to copy a formula down a column but not change the first value. Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |