Ludvig

Splitting one giant formula into three named steps gets most of the compactness back and keeps a place to look.

Thinking in whole columns rather than single cells is the shift, and it takes a while because every tutorial teaches cell-at-a-time.

The concrete win is not elegance, it is that a column formula cannot be missing on one row. Almost every wrong total I have chased in somebody else's sheet was a formula that stopped at row 812 because that is where the data ended when they dragged it.

One formula at the top and the problem cannot happen.