Forum Discussion
Calculate a sum excluding hidden columns, how?
Hi, I’m trying to calculate a total at the end of a row and I have hidden columns. How do I exclude those hidden columns? I’ve tried doing =subtotal and =aggregate but this didn’t work as I’m tryin...
So much--so VERY much--depends on the exact situation.
Like
- how many columns are hidden,
- why are they hidden (if there's a constant condition that could be used in a conditional format, for example)...
- is the design permanent,
- could the hidden columns be moved to the right or left of the column where you want to determine the total?
Personally, I'd want to think about the implications of each of those questions first. Any other solution would potentially be vulnerable to future changes that make the resulting totals unreliable. A good design tries to reduce the risk of unintended side effects. Hidden columns (which admittedly can be useful) are potential time bombs depending on who uses the resulting spreadsheet, how much they're allowed to do, etc.