Player Name Bill Smith Will Johnson Attempts 2015 Football Stats Completions Yards Touchdowns Interceptions QB Rating 122 65 846 5 3 73.55 2 1 15 0 0...

Insert a formula that references the appropriate worksheets in cell C3 on the Offensive Totals worksheet to calculate total completion rate based on data in the Passing worksheet. The completion rate is calculated by dividing the total completed passes by the total attempted passes.