Forum Discussion
Subtotals after each group
You can get subtotals on one line by creating them in one go, then altering the formulas.
But it won't work for the DATETIME_CUST column since it contains text values that Excel doesn't recognize as valid dates and times. It will return 0 as maximum. You'd have to change the values to real date/time values for the SUBTOTAL formulas to work.
See the attached version.
HansVogelaar attached is what i have as an example. In Yellow, this is what the subtotals is producing, in Green is what i would like it to show.
You can get subtotals on one line by creating them in one go, then altering the formulas.
But it won't work for the DATETIME_CUST column since it contains text values that Excel doesn't recognize as valid dates and times. It will return 0 as maximum. You'd have to change the values to real date/time values for the SUBTOTAL formulas to work.
See the attached version.
- Thanks!