Subtotals with OFFSET, ROWS, ROW, and MOD
When you want to create subtotals for a certain amount of row units (3 for quarters, 5 for weekdays, or for whatever periodic feature), you need some fancy formulas that will save you lots of manual work.
When you want to create subtotals for a certain amount of row units (3 for quarters, 5 for weekdays, or for whatever periodic feature), you need some fancy formulas that will save you lots of manual work.