David0227
New Member
- Joined
- Mar 1, 2020
- Messages
- 14
- Office Version
- 2011
- 2010
- 2007
- Platform
- Windows
- MacOS
Hi,
In the 'Home Team' column & 'Away Team' area (Column D & E) the current rows' results SUM all the previous results for that team starting with the row directly above all the way up E.g. Row 15 Column D = SUMIF(B$5:B15,B16,D$5:D15) and Row 15 column E = =sUMIF(C$5:C15,C16,D$5:D15)
I'd like to be able to use the 'Number of Results to Count from bottom up' field (Row 1 column B) which is currently set to 5 (but will change to any number I want) to only count from bottom up the last 5 results (or whatever number I change it to ) results. So in the example below in row 15 column 4, the value would be 0 as it'd only sum Team 1'ss last 5 results from bottom up in Column C which just happens to stop in row 6 in this instance
In the 'Home Team' column & 'Away Team' area (Column D & E) the current rows' results SUM all the previous results for that team starting with the row directly above all the way up E.g. Row 15 Column D = SUMIF(B$5:B15,B16,D$5:D15) and Row 15 column E = =sUMIF(C$5:C15,C16,D$5:D15)
I'd like to be able to use the 'Number of Results to Count from bottom up' field (Row 1 column B) which is currently set to 5 (but will change to any number I want) to only count from bottom up the last 5 results (or whatever number I change it to ) results. So in the example below in row 15 column 4, the value would be 0 as it'd only sum Team 1'ss last 5 results from bottom up in Column C which just happens to stop in row 6 in this instance
Column A | Column B | Column C | Column D | Column E | |
Row 1 | Number of Results to Count from bottom up | 5 | |||
Row 2 | |||||
Row 3 | Home Team | Away Team | Match Result (1 - Home Win, 0 - Draw, -1 Away Win) | Home Team | Away Team |
Row 4 | Team 1 | Team 2 | 1 | ||
Row 5 | Team 2 | Team 3 | 0 | 0 | 0 |
Row 6 | Team 3 | Team 1 | -1 | 0 | 0 |
Row 7 | Team 4 | Team 3 | 1 | 0 | 0 |
Row 8 | Team 1 | Team 2 | 0 | 1 | 1 |
Row 9 | Team 2 | Team 1 | 0 | 0 | -1 |
Row 10 | Team 4 | Team 3 | 1 | 1 | 1 |
Row 11 | Team 3 | Team 2 | 1 | -1 | 1 |
Row 12 | Team 4 | Team 1 | 1 | 2 | -1 |
Row 13 | Team 2 | Team 3 | -1 | 0 | 2 |
Row 14 | Team 3 | Team 4 | -1 | 0 | 0 |
Row 15 | Team 1 | Team 4 | 0 | 1 | -1 |