Forum Discussion

melyoni's avatar
melyoni
Copper Contributor
Oct 21, 2021
Solved

dynamic array excel sum

Hi,   I have a list with names and amounts. Each name appears several times, and not all of them have amounts (attached).   How (using dynamic array) can I create a list of the total amounts by ...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Oct 21, 2021

    JKPieterse why not using LET()?

    =LET(comp,UNIQUE(Table1[Company Name]),totals,SUMIFS(Table1[Total outstanding anount],Table1[Company Name],comp),tab,CHOOSE({1,2},comp,totals),SORT(tab,2,-1))
melyoni's avatar
melyoni
Copper Contributor
Oct 21, 2021

JKPieterse 

Thanks!

no way to do it with out the middle table?

JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 21, 2021
Not yet. Perhaps if Microsoft adds matrix functions to join two arrays into a single matrix.

Resources