Simple Formula Question
 

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

Simple Formula Question
 

Try

=A1/$D$1


The dollar signs create an absolute (fixed) reference.
Mike

"Dax Arroway" wrote:

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

Simple Formula Question
 

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


--
Biff
Microsoft Excel MVP


"Dax Arroway" wrote in message
...
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

Simple Formula Question
 

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

Simple Formula Question
 

On Feb 5, 3:42*pm, Cortez wrote:
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

Ignore that. Duh.