Question description:
This user has given permission to use the problem statement for this
blog.
I need to figure a percentage of contribution of the grand total on multiple rows. Grand total is in a fixed location. I know there is a way to have the calculation done on cells going down the page (perhaps using the $ sign). Tried to use $B2/B18*100, but it only works on the first instance. If you could just tell me the name of this feature, I could look it up myself. Thanks
Solved by T. L. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/07/2018 - 04:04
Hi
User
05/07/2018 - 04:04
hello
Excelchat Expert
05/07/2018 - 04:04
It's pleasure to help you today.
Excelchat Expert
05/07/2018 - 04:05
I can see the problem.
Excelchat Expert
05/07/2018 - 04:05
You have to add "$" to both row and column.
Excelchat Expert
05/07/2018 - 04:05
$B2/B18*100
Excelchat Expert
05/07/2018 - 04:05
In this what is the total row? 2 or 18?
User
05/07/2018 - 04:06
18
Excelchat Expert
05/07/2018 - 04:06
Ok. in that case, you have fix B18 as follows.
Excelchat Expert
05/07/2018 - 04:06
=B2/B$18*100
User
05/07/2018 - 04:06
oops, should be B18
Excelchat Expert
05/07/2018 - 04:07
Yes. It is the one fixed for all.
Excelchat Expert
05/07/2018 - 04:07
So, you have fix for row 18.
Excelchat Expert
05/07/2018 - 04:07
B is not requird to be fixed. As, the same column you are using for the calculations.
User
05/07/2018 - 04:09
so, what is the name of this functionality?
Excelchat Expert
05/07/2018 - 04:09
Sorry, i did not get?
User
05/07/2018 - 04:10
"fixed" is the name of the functionality?
Excelchat Expert
05/07/2018 - 04:10
It is fixed either row or column and is called "Absolute reference"
User
05/07/2018 - 04:10
Thanks, that will fulfill my question. goodby
Excelchat Expert
05/07/2018 - 04:11
Thank you.
Excelchat Expert
05/07/2018 - 04:11
Have a great day ahead.
Excelchat Expert
05/07/2018 - 04:11
Please visit Got It Pro.
Excelchat Expert
05/07/2018 - 04:13
Please leave a great feedback after ending the session.
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.