Excel Dynamic Array Totals

We can now add Dynamic Row and Column Totals to Excel Dynamic Arrays

Recently release in the Insider (Beta) channel for Excel are the new BYCOL and BYROW Lambda Helper functions  

3:40 The Problem..
4:24 Lambda BYCOL and BYROW

Here's a link to the file I used (as at December 2021 you still need an install of the Insider Version of Excel for this to work...   https://aasolutions.sharepoint.com/:f...



More Info on Lambda Helper Functions
https://techcommunity.microsoft.com/t...

BYCOL https://support.microsoft.com/en-us/o...


Office Insider
https://insider.office.com/en-us/


Overview of Channels
https://docs.microsoft.com/en-us/depl...


Link to my AutoCorrect video Faster Excel formula writing using Au...