Copying a mixed reference formula
 

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?

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.

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.

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.

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.

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.

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.