Percentage of Multiple Rows
 

I'm trying to copy a formula.

The worksheet has 10 rows of numbers and I want to find what percentage of
the total each row equals. As my starting formula, I've entered "=A1/A11"
I then copy the formula and paste it into rows 2-10. But what I end up with
are formulas reading "=A1/A12," "=A1/A13," "=A1/A14" and so on.

How do I keep the dividing number constant?

Thanks.

Percentage of Multiple Rows
 

"Hugh" wrote:
How do I keep the dividing number constant?

Although I don't really understand what you are trying to do, try dividing
by $A$11 instead of A1.


----- original message ----

"Hugh" wrote in message
...
I'm trying to copy a formula.

The worksheet has 10 rows of numbers and I want to find what percentage of
the total each row equals. As my starting formula, I've entered "=A1/A11"
I then copy the formula and paste it into rows 2-10. But what I end up
with
are formulas reading "=A1/A12," "=A1/A13," "=A1/A14" and so on.

How do I keep the dividing number constant?

Thanks.

Percentage of Multiple Rows
 

That works. Thanks for your help.

"JoeU2004" wrote:

"Hugh" wrote:
How do I keep the dividing number constant?

Although I don't really understand what you are trying to do, try dividing
by $A$11 instead of A1.


----- original message ----

"Hugh" wrote in message
...
I'm trying to copy a formula.

The worksheet has 10 rows of numbers and I want to find what percentage of
the total each row equals. As my starting formula, I've entered "=A1/A11"
I then copy the formula and paste it into rows 2-10. But what I end up
with
are formulas reading "=A1/A12," "=A1/A13," "=A1/A14" and so on.

How do I keep the dividing number constant?

Thanks.