L
lea
how do i get the exact percentage of each cell in a row of numbers from the
total row amount
total row amount
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
ryguy7272
Exact percentage? Can you post a sample of your data as it is now, and
describe what you would like to see?
Regards,
Ryan--
describe what you would like to see?
Regards,
Ryan--
G
Gaurav
If your data is in A1:A10 and the SUM is in A11 enter the following in B1
=A1/$A$11
Right click on B1, select percentage. Now drag it down.
Is this what you want?
=A1/$A$11
Right click on B1, select percentage. Now drag it down.
Is this what you want?
L
lea
Thanks, that was great
Gaurav said:If your data is in A1:A10 and the SUM is in A11 enter the following in B1
=A1/$A$11
Right click on B1, select percentage. Now drag it down.
Is this what you want?
G