I have a spreadsheet that goes across the screen, this is grouped by month and I need the totals to change when each is grouped or ungrouped.
i.e. B4 shows 1720 which is a sum of data from E4:Z4, as E4:Z4 is grouped the sum of 1720 needs to change and reflect this.
I have a trend line on the left measuring the data which changes as the columns are grouped/ungrouped and this is how I need the cell in B4 to operate
i.e. B4 shows 1720 which is a sum of data from E4:Z4, as E4:Z4 is grouped the sum of 1720 needs to change and reflect this.
I have a trend line on the left measuring the data which changes as the columns are grouped/ungrouped and this is how I need the cell in B4 to operate