MicrosoftThanks for posting these screenshots, I doubt I'll have access to this functionality for a while from current channel so will follow your posts with interest.
My optimism follows other approaches to modelling including computational notebooks and scripting languages that have been gaining acceptance in recent years and represents a growing community who are willing to move with the times - admittedly still a minority of users.
The suggestions above were targetted more at a typical office worker who may well want to use these functions but without necessarily including LAMBDA which may be a little daunting initially. For an indication of potential interest, a uservoice request for SUMROWS and SUMCOLS equivalent array functions has 300+ votes.
