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.

Using your example above, in cell C2 enter the formula: =B2/VLOOKUP(A2,$A$13:$B$16,2,0)

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

See how that works.

MIKE

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

Steve

Ask Your Question

Weekly Poll