Forum Discussion
Different functions for each column in a subtotal
ive got a sheet where i want to subtotal using different functions in different columns. i will always have different data every time i want this to execute, so cant hardwire the row range, also each...
That requirement is served by a new(ish) function introduced within 365. Using OliverScheurich​ data
= GROUPBY(Date, Values, HSTACK(SUM, COUNT, MAX), , 0)gives the desired results, sorted by date.