Excel excels because if fills the 2D user interface. But not separating calculations from the tabular position in the UI is a historical failure and things like this is a band aid on that
OTOH, LAMBDA and LET enable moving the core of some calculations into user defined functions in the Name catalog. And Tables fix a lot of the cell reference issues though they need a lot of improvement to handle array spills.
I sometimes wonder about an excel-like interface where the tables and columns can be given names, reducing errors from incomplete ranges. It would be like reinventing a database though.
https://support.microsoft.com/en-us/excel/using-structured-r...