I want to set up a column of numbers
at the bottom I want to show a total of the numbers
in column b I want to show what % column a is of the total
That's easy enough, but when I copy and paste the total tries to move down a
row skewing my calculations.

In other words in the formula in cell b1 =a1/sum(a1:a10)
when I copy and paste it to cell b2 it becomes =a2/sum(a2:a11)
and I want the sum portion to remain constant
- in other words =a2/sum(a1:a10)

Please help.

Thank you

Vivian