I have started recording a new betting trend idea on the NBA first and second half O/U scores. I need some help with getting some info to auto calculate in excel. If you have a look at the spreadsheet you can see I have separated out the home team in column A and the away team in column B and I have just been keeping record manually of what all of the scores have been against the lines over the past few weeks. The second half Under has been staying consistently over 60% in the win column. I started noticing a trend of teams that were going over in the second half so I am looking to keep track of each team and weather they go over or under in both the first and the second half. If you have a look at the bottom of the spreadsheet you will see I have listed every NBA team and I have cells created to record how many times a team goes over or under the total in both the first and second half of games. Could someone help me formulate these cells so that when I put new games in each day it will look for each team and add up the over under column automatically? Here is the link to my spreadsheet https://spreadsheets0.google.com/ccc...COud480C#gid=0
Any help would be appreciated.