chandrashekar
Well-known Member
- Joined
- Jul 15, 2005
- Messages
- 529
- Office Version
- 365
- Platform
- Windows
Hello,
How to write formula for % of Row total(Image2 for reference) for below table
I need to get result as Column D & E.
Regards,
Chandrashekar B
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