Create a formula that pulls the count for each ball from the first table and displays it in a separate column (note: you CANNOT copy and paste a formula to do this. Unfortunately, you just have to build each formula individually). Repeat this process to pull the On Target results from its pivot table and display those in another column. After you have that data out of your pivot table, you should then be able to calculate the following: a) The number of Off-Target shots b) The On-Target % c) The Off-Target % A B C D Result 1 2 3 Count of Result E On Target Y F G H I Count of Result 4 Ball Total Ball Total Count On Target 5 Bridgestone 942 Bridgestone 749 942 6 Chrome Soft 795 Chrome Soft 634 795 7 Chrome Soft X 1,257 Chrome Soft X 1,017 1,257 8 Taylor Made 629 Taylor Made 514 629 9 Titleist AVX 929 Titleist AVX 767 929 10 Titleist Pro V 914 Titleist Pro V 746 914 11 Titleist Pro Vx 728 Titleist Pro VX 606 728 12 Titleist Tour Soft 750 Titleist Tour Soft 615 750 13 Titleist Tour Speed 555 Titleist Tour Speed 435 555 14 Z-Star 770 Z-Star 647 770 15 Grand Total 8,269 Grand Total 6,730 8,269 16 17