Add a floating totals row to dynamic arrays
When using dynamic arrays, it would be nice to have the option of a floating totals row at the bottom of the dynamic spill range.
Charles Williams commented
I agree. One way of doing it is to create a TOTALS(dynamic array create formula) function that wraps the formula that creates the dynamic array. The output is then the dynamic array plus an extra row of totals.
See http://www.decisionmodels.com/fxlv4_speedtools_beta1.htm for a working example of TOTALS
Wyn Hopkins commented
Kevin Osborn commented
Actually if MS fixed (improved) dynamic arrays such that it can be placed inside a table the totals would be there via the table total row. Unfortunately at this time since a dynamic array cannot exist inside a table we have this problem as well as losing the ability to used structured reference for dynamic arrays (which are essentially a table).
Hussein Korish commented
Yes ...exactly as i wanted to say
Yes, this is very needed.
Not just totals, but any other function in the totals row that Tables have.
David Ringstrom commented
Yes, please. That would be incredibly useful.