video1.0<iframe src="https://www.loom.com/embed/17a8d42c72164ec993a4058301daa349" frameborder="0" width="1670" height="1252" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>12521670Loomhttps://www.loom.com12521670https://cdn.loom.com/sessions/thumbnails/17a8d42c72164ec993a4058301daa349-99d22db5896e06fb.gif442.507I’m showing a critical way to avoid dragging formulas down when building Income and Expense sections with accounts and subaccounts using dynamic arrays. In my example I reference the entire spill range using hash notation with INDEX column 1 and column 2, so the results expand or shrink automatically when the account ranges change. I also use totals based on full array ranges to prevent spill and ref errors when adding more accounts. Then I set Auto-hide using Hide zero rows and Hide consecutive blank rows so blank rows do not clutter the sheet. No action is required, but tell me if you want help applying it to your template. Community post and sample file is here: https://community.velixo.com/support/discussions/topics/153001058501