Solved Calculating % in a Data Table

Microsoft Office excel 2003
July 25, 2013 at 13:35:40
Specs: Windows Vista, Pentium 2.6 GHz; 4GB RAM
Calculating % of Unique Sport
I just had some great help with most of this but, forgot I am missing one important part. Calculating percentages. See my screen capture. I need a formula that will calculate the percentage each row is of the total for that unique sport. Not having any luck with the stuff I've seen so far. Thanks for your help.

See More: Calculating % in a Data Table

Report •

July 25, 2013 at 14:40:42
✔ Best Answer
Using your example above, in cell C2 enter the formula:


Format column C as Percent with at least 2 decimal places.

See how that works.


Report •

July 26, 2013 at 07:18:15

Thank you very much! This formula I can understand. I get the logic and it really helped solve my problem.


Report •

Related Solutions

Ask Question