|re: is there a simpler way to make it B2:Indefinite?|
You could define a Dynamic Named Range and use that in your formula.
If you define a Named Range that refers to this formula, the Range will be B2:B(LastRowWithData) assuming there are no blank cells within the Data:
However, is including B1 really a problem? Does including B1 cause the SUMIFS to return the wrong results?
re: is there a way to have an increment of 9 cells as you drag down?
If you put this in any cell it will refer to Sheet1!A9. As you drag it down, it will increment by 9 rows in each cell:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.