keeping parts of a formula same

K

Koji

I need to ask a simple question which involves when
draging the formula to the cells below to make copies.

If I had a Fromula like say

=A5/SUM(B5:B103)*B5

and I want to drag it to a couple of cells below making
copies and saving my self some time. How to I prevent one
part of the formula from changing. Because when I drag in
down to the other cells I only want *B5 to change to
*B6,*B7,*B8,*B9 etc. etc. so is there any way to do this?
 
D

DNF Karran

Put $ in front of any references you want to keep the same ie

=$A$5/SUM($B$5:$B$103)*B5

You can also use this to keep partial refs constant eg $A1 which wil
mean A will stay the same when you drag right and the 1 will rise a
you drag down.

Dunca
 
D

DDM

Koji, search the topic "cell and range references" in Excel help and read
about relative and absolute cell references. If you want to copy your
formula down while preserving the row references, change your formula to:

=A$5/SUM(B$5:B$103)*B5.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
K

Koji

Thank you very much. I had once received help with a
formula and had "$" in it as well, but i guess now this
clearly explains things a lot more.

Thank you again for the help and explanation.
 
Top