Controlling which parameteres change in fill functions
 

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.

Controlling which parameteres change in fill functions
 

Hi,

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

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

"koahzvika" wrote:

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.

Controlling which parameteres change in fill functions
 

=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

On Fri, 26 Sep 2008 02:25:01 -0700, koahzvika
wrote:

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.