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 thanks for that! Is there anyway to have the subtotals on the same line? I want to have max of two columns then a sum of another column, but it is creating two separate lines?
Can you explain in more detail what you want to do, perhaps attach a sample workbook?
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!