Controlling which parameteres change in fill functions

[koahzvika]

If I have a function I want to fill down a column, and I want certain
parameters to change and others to stay the same, how do I control which
values go +1 and which ones stay the same?
For example,

Function:
=SUM(A1:A2)/(B2-B1)

Fill as:
=SUM(A1:A3)/(B3-B1)
=SUM(A1:A4)/(B4-B1)
=SUM(A1:A5)/(B5-B1)
etc.

 

[Mike H]

Hi,

try this and note the $ signs which make those references absolute

=SUM($A$1:A2)/(B2-$B$1)
Mike

 

[Gord Dibben]

=SUM($A$1:A2)/(B2-$B$1)

More on this can be found in help under absolute and relative references


Gord Dibben MS Excel MVP