Question description:
This user has given permission to use the problem statement for this blog.
percentage of a number that is one of the total od the column
Solved by C. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert
27/08/2018 - 07:00
Hi
Excelchat Expert
27/08/2018 - 07:00
It's pleasure to help you today.
Excelchat Expert
27/08/2018 - 07:00
You want to get the percentage based on the total of numbers in other column?
User
27/08/2018 - 07:01
yes
Excelchat Expert
27/08/2018 - 07:01
I can show with an example. However, if you have any further example, please paste in preview.
User
27/08/2018 - 07:01
i used to know how. It won't work for me now
Excelchat Expert
27/08/2018 - 07:02
I have entered the sample numbers in column A.
User
27/08/2018 - 07:02
ok
Excelchat Expert
27/08/2018 - 07:02
And i am calculating % in column B.
Excelchat Expert
27/08/2018 - 07:02
=A1/sum(A:A)
Excelchat Expert
27/08/2018 - 07:02
Using above formula and applied % formatting.
User
27/08/2018 - 07:05
A4/b1= is the formula I know. then copy it to all columns automatically changong the cell number
Excelchat Expert
27/08/2018 - 07:06
A4 / B1?
User
27/08/2018 - 07:06
6?8.33&
Excelchat Expert
27/08/2018 - 07:06
B1 is calculated % value based on the sum of column A numbers. It calculates the % of A1.
Excelchat Expert
27/08/2018 - 07:07
Can you please write your specific example in preview?
User
27/08/2018 - 07:07
6/8.33
Excelchat Expert
27/08/2018 - 07:07
Can you please let me know the your requirement? You want to calculate 6 / 8.33?
Excelchat Expert
27/08/2018 - 07:08
6 is a number in the series. and 8.33% is based on 1.
Excelchat Expert
27/08/2018 - 07:08
Ok. I see numbers in column D
Excelchat Expert
27/08/2018 - 07:09
=D1/D$5
Excelchat Expert
27/08/2018 - 07:09
I have fixed D5. 5th Row.
Excelchat Expert
27/08/2018 - 07:10
And when i dragged downwards, the reference won't change.
Excelchat Expert
27/08/2018 - 07:10
E2=D2/D$5
Excelchat Expert
27/08/2018 - 07:13
You want to calculate E1/31?
User
27/08/2018 - 07:13
I did it successfully on your spreadsheet but it won't work on mine
Excelchat Expert
27/08/2018 - 07:13
Please share yours.
Excelchat Expert
27/08/2018 - 07:14
Not, why you are calculating G column after calculating % values in column E?
Excelchat Expert
27/08/2018 - 07:15
You can download the file from File / Download as Excel
User
27/08/2018 - 07:17
Forget the whole thing
User
27/08/2018 - 07:17
thank you
Excelchat Expert
27/08/2018 - 07:18
What is the problem you are having? Hope, you understood the concept? However, if the problem is solve that is fine. Thank you. Visit Got It Pro.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.
