ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Want a percentages of a single cell divided by a column of cells (https://www.excelbanter.com/excel-worksheet-functions/124794-want-percentages-single-cell-divided-column-cells.html)

dbog

Want a percentages of a single cell divided by a column of cells
 
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

Max

Want a percentages of a single cell divided by a column of cells
 
Hazarding a guess that
the dollar sign ($) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The $ sign in A$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.




Pete_UK

Want a percentages of a single cell divided by a column of cells
 
You need to make the cell reference for the second cell absolute - you
use the dollar symbol $ for this, for example:

=A2/A$1

When you copy this down it will become:

=A3/A$1
=A4/A$1

etc.

Hope this helps.

Pete

dbog wrote:

Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.



dbog

Want a percentages of a single cell divided by a column of cel
 
Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.

"Max" wrote:

Hazarding a guess that
the dollar sign ($) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The $ sign in A$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.





Max

Want a percentages of a single cell divided by a column of cel
 
You're welcome !
Thanks for feeding back to us ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.





All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com