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.
Randy
shared this idea
8 comments
-
Zia Siddique
commented
It would be really useful to have floating totals with the filter function for the new dynamic arrays.
-
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
-
Anonymous
commented
Yes, this is very needed.
-
Anonymous
commented
Not just totals, but any other function in the totals row that Tables have.
-
David Ringstrom
commented
Yes, please. That would be incredibly useful.