There are 2 tabs in about the center of the worksheet; see RECORD (cell L4) of whichever team. Based on the RESULT/SCORE (cells F13,F19,F25,F31,F37,F43,P13,P19,P25,P31,P37,P43) where the 'W/L' are located I'd like a number to increase in the cells (L6 or N6). This will update based on the score of each game or once I place an 'L' or 'W' in the appropriate cell.
1. What formula can be created based on the scores of each game? Depending on the tab the cell to the right of 'W/L' will be the home team and if it's possible I'd like a number to increase based on the score of a game.
2. What formula can be created to give me this data?
Not sure if either questions 1/2 can be answered but I wanted to ask to make it easier to update.
Thank you,
Tim I.
Bookmarks