I am trying to develop a golf scorekeeping spreadsheet that keeps track of 2 different matches within the round. one team best ball match with auto 1 down presses and one high low match with auto 1 down presses. here is the link to the spreadsheet with the results of the matches manually filled in. I need help to come up with the right formulas to get the sheet to work. here is the link to the sheet https://docs.google.com/spreadsheet/ccc?key=0AmK8MqI8U5bfdDRQNDAxYjZ3bGlpM0cxbEpvUUhwN3c#gid=1

any help would be most appreciated