As a good practice have all aggregate functions which work on entire column (table-region data) defined in the header region as this is not affected by view sort/filter formula adjustments.
Eg: Total Budget: =AGGREGATE(9,0,F5:F)
Also notice, having unbounded range-end for budget column i.e. F5:F which selects all cells in column F from row-index 5 ( i.e. start of table region ) to the last cell in that column.
Additionally to ensure, sub-totals are not considered in the aggregate results, consider using the following aggregate function alternatives instead of SUM, AVERAGE etc. :
Define the aggregate formula in header region using AGGREGATE/SUBTOTAL and also each parent cell aggregate formulas as AGGREGATE/SUBTOTAL.
