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
.
|