Forum Discussion
sum( ) columns with labels
I have an attendance sheet with dates across the column tops and members down the rows. There are groups of members that need to be summed as a group and added to the grand total. I'd like to use...
I'd define the groups in the sheet itself:
Click anywhere in the data, then click Subtotal on the Data tab of the ribbon.
Specify that you want a subtotal on each change in Group, and that you want subtotals for each of the columns labeled 1, 2, ...:
Click OK. You get group subtotals and grand totals, and outline buttons to expand/collapse the data.