Posted 8 September 2017, 2:12 pm EST
I have a situation where i have to sum of a list of values for two departments.
The list contains all the employees in both departments and I have a sum at the bottom of the column (using SUM function). This all works fine but I have a department filter and I want this sum to reflect the sum of the non-filtered rows. Note that I had to change the totals rows once the filter is applied so that it matches the filter string so the totals row will show up.
I can do this with some manual coding but since I have many of these totals on the sheet, I'm worried about the performance. So is there was a way the SUM function can ignore hidden cells with the specified range?