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.