software

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
=A1/SUM($A$1:$A$10)
=A2/SUM($A$1:$A$10)

You need absolute value, when you select the range press F4--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=523353gt; =A1/SUM($A$1:$A$10)

and with the above entered in B1,
to copy B1 down, we could simply drag the fill handle
(i.e. the quot;black squarequot; at the bottom right-hand corner of cell B1)
instead of:
gt; .. I copy and paste it to cell b2 ...

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Thanks a lot. That was the help I needed.

quot;Maxquot; wrote:

gt; gt; =A1/SUM($A$1:$A$10)
gt;
gt; and with the above entered in B1,
gt; to copy B1 down, we could simply drag the fill handle
gt; (i.e. the quot;black squarequot; at the bottom right-hand corner of cell B1)
gt; instead of:
gt; gt; .. I copy and paste it to cell b2 ...
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

You're welcome, Viviank !
Thanks for feeding back ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Viviankquot; gt; wrote in message
...
gt; Thanks a lot. That was the help I needed.
On Fri, 17 Mar 2006 21:19:23 0800, quot;Maxquot; gt;
wrote:

gt;You're welcome, Viviank !
gt;Thanks for feeding back ..

of course, you have already calculate the sum
so b1 = a1/$a$11
and then drag b1 down to b10
would save 10 extra calculations--

Steve