Ok guys I am working on a spreadsheet and could use some help


I got a sheet where I need to pull the numbers listed under the columns


for example I have cut and pasted my data below. It did not paste well however I think you might be able to still figure it out.

I need to know how many Game 1's are being played in each week
and I need to know how many Game 2's are being played in each week.

Matt

Teams Game 1 Week # Game 2 Week # Game 3 Week #
Florida Gators Troy 2 Tennessee 3 At Kentucky 4
Texas Longhorns At Wyoming 2 UTEP 4 Colorado 6
USC Trojans San Jose State 1 At Washington 3 Washington State 4
Oklahoma Sooners Tulsa 3 Baylor 6 Kansas State 9
LSU Tigers At Washington 1 Vanderbilt 2 UL Lafayette 3