Add a column to the right of the Short Gains column created in A titled Play Category - a more detailed approach to summarize each play. This will require a reference table adjacent to the existing data with the following categories based upon yards gained: Bad Play (negative yardage plays), Short Gain (0 - 9), Medium Gain (10-19), Large Gain (20-39), and Big Play (40 or more). Use a XLOOKUP function in the Play Category column to assign play categories to each record - you Add a column to the right of the Short Gains column created in A titled Play Category - a more detailed approach to summarize each play. This will require a reference table adjacent to the existing data with the following categories based upon yards gained: Bad Play (negative yardage plays), Short Gain (0 - 9), Medium Gain (10-19), Large Gain (20-39), and Big Play (40 or more). Use a XLOOKUP function in the Play Category column to assign play categories to each record - you