I want to use a less complicated formula to achieve the answer to cell D28 in this sample spreadsheet
I was wondering if there was a way to group the offset cells together in a set so I didn't have to repeat the redundant parts of the formula.
The formula is to separate the data from the columns above into six different sections based on the number of rows without blanks. The number of rows is dynamic so that is why I used the technique I did.
I considered using the date column to achieve this but didn't know how. the actual use case has many more rows than the example which is why dividing into six groups is useful.