Copying a mixed reference formula

[Sarah]

This is best asked as an example. If I am using a mixed reference formula in
several cells ie cell B2 contains A2/A$1 and cell B3 contains A3/A$1, is
there any way to copy the reference having it increase each time ie cell B5
contains A5/A$4 and cell B6 contains A6/A$4?

[Rutgers_Excels]

How often do you want the divisor to increase and by how much? 3 rows for every 3 cells? This can be done depending on what exaclty you are looking for.

[Dave O]

What's the pattern of the cell references as you progress from B2 to B3
to B4 to B5 to B6? I didn't see a regular progression.

[Sarah]

Cell A1 contains a total, while cells A2 and A3 would contain values that add
to the total in cell A1. I would like to calculate percentage of total for
cells A2 and A3. Cell A4 would contain a different total, the sum of cells A5
and A6. Does that help?

"Dave O" wrote:

> What's the pattern of the cell references as you progress from B2 to B3
> to B4 to B5 to B6? I didn't see a regular progression.
>
>

[Transplanted Buckeye]

Looks like you just need to remove the absolute reference ($) and copy the
formulas, therefore making the cell references relative.

"Sarah" wrote:

> Cell A1 contains a total, while cells A2 and A3 would contain values that add
> to the total in cell A1. I would like to calculate percentage of total for
> cells A2 and A3. Cell A4 would contain a different total, the sum of cells A5
> and A6. Does that help?
>
> "Dave O" wrote:
>
> > What's the pattern of the cell references as you progress from B2 to B3
> > to B4 to B5 to B6? I didn't see a regular progression.
> >
> >

[Sarah]

but if i remove the absolute reference then when i divide A2 by A1 and copy
the formula it will change to divide A3 by A2 when i would like it to divide
A3 by A1 and do this for a few hundred different sets of 2.

"Transplanted Buckeye" wrote:

> Looks like you just need to remove the absolute reference ($) and copy the
> formulas, therefore making the cell references relative.
>
> "Sarah" wrote:
>
> > Cell A1 contains a total, while cells A2 and A3 would contain values that add
> > to the total in cell A1. I would like to calculate percentage of total for
> > cells A2 and A3. Cell A4 would contain a different total, the sum of cells A5
> > and A6. Does that help?
> >
> > "Dave O" wrote:
> >
> > > What's the pattern of the cell references as you progress from B2 to B3
> > > to B4 to B5 to B6? I didn't see a regular progression.
> > >
> > >

[Transplanted Buckeye]

Do the first two - =+A2/A1 and =+A3/A1 - manually and then copy these.
When you copy these, they will be relative to the new sets.

Is the following in each cell:
A1: =SUM(A2..A3)
A2: a number
A3: another number
B1: =+A2/A1
B2: =+A3/A1

If it is, enter the formulas manually and use this block, A1 to B3, as your
template

"Sarah" wrote:

> but if i remove the absolute reference then when i divide A2 by A1 and copy
> the formula it will change to divide A3 by A2 when i would like it to divide
> A3 by A1 and do this for a few hundred different sets of 2.
>
> "Transplanted Buckeye" wrote:
>
> > Looks like you just need to remove the absolute reference ($) and copy the
> > formulas, therefore making the cell references relative.
> >
> > "Sarah" wrote:
> >
> > > Cell A1 contains a total, while cells A2 and A3 would contain values that add
> > > to the total in cell A1. I would like to calculate percentage of total for
> > > cells A2 and A3. Cell A4 would contain a different total, the sum of cells A5
> > > and A6. Does that help?
> > >
> > > "Dave O" wrote:
> > >
> > > > What's the pattern of the cell references as you progress from B2 to B3
> > > > to B4 to B5 to B6? I didn't see a regular progression.
> > > >
> > > >

[Sarah]

You are brillant. Thanks so much.

"Transplanted Buckeye" wrote:

> Do the first two - =+A2/A1 and =+A3/A1 - manually and then copy these.
> When you copy these, they will be relative to the new sets.
>
> Is the following in each cell:
> A1: =SUM(A2..A3)
> A2: a number
> A3: another number
> B1: =+A2/A1
> B2: =+A3/A1
>
> If it is, enter the formulas manually and use this block, A1 to B3, as your
> template
>
> "Sarah" wrote:
>
> > but if i remove the absolute reference then when i divide A2 by A1 and copy
> > the formula it will change to divide A3 by A2 when i would like it to divide
> > A3 by A1 and do this for a few hundred different sets of 2.
> >
> > "Transplanted Buckeye" wrote:
> >
> > > Looks like you just need to remove the absolute reference ($) and copy the
> > > formulas, therefore making the cell references relative.
> > >
> > > "Sarah" wrote:
> > >
> > > > Cell A1 contains a total, while cells A2 and A3 would contain values that add
> > > > to the total in cell A1. I would like to calculate percentage of total for
> > > > cells A2 and A3. Cell A4 would contain a different total, the sum of cells A5
> > > > and A6. Does that help?
> > > >
> > > > "Dave O" wrote:
> > > >
> > > > > What's the pattern of the cell references as you progress from B2 to B3
> > > > > to B4 to B5 to B6? I didn't see a regular progression.
> > > > >
> > > > >