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.
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.