Simple Formula Question

  • Thread starter Thread starter Dax Arroway
  • Start date Start date
D

Dax Arroway

I have a column with numbers that's sumed at the bottom. I want another
column with percents next to them but I'm having trouble using the fill
handle and I don't want to go all the way down the list filling in the
formulas for the each row of the table throughout the entire column. There
must be an easier way. Can someone please help.

So, I've got
ColA
A1 12
B1 14
C1 50
D1 SUM(A:A)

What I want is the percent the cell is of the sum listed next to the number.
So I want:
ColB
B1=A1/D1
B2=A2/D1
B3=A3/D1

When I use the fill handle I get:
B1=A1/D1
B2=A2/D2
B3=A3/D3
Both sides incement up.
(Which of course gives me a divided by zero error because there's noting in
cells D2 or D3!)

So, the question is how to I paste/copy/fill the formula into the rest of
the cells down column B so the first called cell part increments but the
later part doesn't?

I hope this is clear. And thank you for any help you provide in advance.
(Seems like a simple question but maybe not). I've tried putting parentheses
around each of the parts but they still increment up and that's as far as my
excel knowledge will take me. Any help?
--Dax
 
Make the reference to D1 absolute:

=A1/D$1

Now when you copy down you'll get:

=A1/D$1
=A2/D$1
=A3/D$1
etc
etc
 
Select the column that the formula is in by the column header, go to
Edit/Replace and replace all D/ with D/$

That will fix your error also.

TK
 
Select the column that the formula is in by the column header, go to
Edit/Replace and replace all D/ with D/$

That will fix your error also.

TK
Click to expand...

Ignore that. Duh.
 
Back
Top