Hello, hoping someone can help, there have been similar questions for a formula such as this, but I haven't seen it in row form. I am looking to achieve the # in column answer. The rows #'s for the date in which they appear, I only want to count in sequence from the start # i the last cell (9/14) to the last # before the blank cell. Please can anyone assist?
| Row Labels | 9/8/2020 | 9/9/2020 | 9/10/2020 | 9/11/2020 | 9/12/2020 | 9/13/2020 | 9/14/2020 | ANSWER |
| A | 1 | 0 | ||||||
| B | 1 | 1 | 2 | 1 | 1 | 1 | 2 | |
| C | 1 | 1 | 1 | 1 | 1 | 1 | 4 | |
| D | 1 | 1 | 1 | 0 | ||||
| E | 1 | 1 | 1 | 0 | ||||
| F | 1 | 1 | 1 | 1 | ||||
| G | 1 | 1 | 1 | 1 | 1 | 1 | 3 | |
| H | 1 | 1 | 1 | |||||
| I | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 |
| J | 1 | 0 | ||||||
| K | 1 | 1 | 1 | 0 | ||||
| L | 1 | 1 | 1 | 1 | 2 | |||
