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.