I have an excel table, I want to group one column and when the column is shown, the total value of the row should change and if I hide it, the total value of the row should change.
Attached is an example table of what I am working. By 'hiding' column E column F should be dynamic. Is this possible and any pointers in the direction would be great. Thank you.
grouping cells.xlsx
Bookmarks