Subtotal References Extends Too Far In Lists Upon New Row

I have attached my relevant spreadsheet. I have an Active List of regional numbers per Site (Branch) for our office Their is about 8 records (rows) already in the list and the rightmost column is my "Running Total" (RunT) column with Formula "=--SUBTOTAL(109,$F$2:F2)" This formula was copied and pasted downwards for the 8 existing records. It then of course adapts and extends the range of the formula accordingly. That is why only the one side is pegged ($F$2). It works great as a running total for any filter cenario I choose for the existing 8 records.

NOW, however, if the user adds another record/row, the Total Column Autofills
the next row's formula correctly as is the advantage of Excel's "Active declared"
Lists. BUT, the Running total column (RunT) with the subtotal formula goes all
weird and autofills the next row formula in such a way so that it changes the
previous row's formula and from then on the range it uses (in the subtotal expression) always updates itself backward up and until the point of the first user-entered record. It changes ALL the Subtotal formula-ranges of the user-entered rows! This is very unusual and unfortunate. This ruins the whole idea of having a "per row" running total on the right end of my list that is always correct even if I filter the list.