Excel Formula : % of Row Total

[chandrashekar]

Hello,

How to write formula for % of Row total(Image2 for reference) for below table

I need to get result as Column D & E.

Pri	Ach	Bre	% of row total(Ach)	% of row total(Bre)	Excel Formula(% of row total(Ach)	Excel Formula(% of row total(Bre)
S1	84​	1​	98.82%​	1.18%​
S2	457​	2​	99.56%​	0.44%​
S3	975​	2​	99.80%​	0.20%​
S4	4​		100.00%​	0.00%​
S5	2​		100.00%​	0.00%​
Total	1522​	5​	99.67%​	0.33%​

Regards,
Chandrashekar B

 

[Legacy 143009]

Column D:

=1-(C2/B2)

Column E:

=C2/B2

Then, in the number formatting, format them as %.

 

[chandrashekar]

Column D:

=1-(C2/B2)

Column E:

=C2/B2

Then, in the number formatting, format them as %.

Thank you

Regards,
Chandrashekar B

 

[Legacy 143009]

Thanks for the feedback

 

[Joe4]

chandrashekar,

In the future, when marking a post as the solution, please mark the original posting that contains the solution, not your own post acknowledging that some other post was the solution.
I have updated this for you on this thread.