Forum Discussion
Creating subtotals within an array formula
I need to create subtotals of data spawned by the =SORT and =FILTER functions. I can do it the old fashioned, hard, way by comparing the value in the current row against the most previous value and i...
I don't have the Sort/Filter functions, so I can't re-create your scenario or test a solution.
But, if it helps, this formula will create an array of subtotals. Perhaps you can incorporate it or see if it gives you any ideas.
