0

I'm building a data set and one of the tables is based on filtered values. I'm using the =subtotal function to sum the data, but every time I change filters all my data gets messed up. Is there a way to "lock" filtered data?

1
  • 1
    Hi and welcome. You said "every time I change filters all my data gets messed up". Would you please explain exactly what you mean by "messed up" - a before and after example would be useful (you could include screenshots). You're using subtotal - but you didn't explain the location or the specific range of this formula. If the formula was placed, say, above the filtered data, and the range was flexible enough to cope with a change in the number of rows of data, then the formula might not be affected. These are examples of why you need to provide more detailed information.
    – Tedinoz
    Oct 9 at 4:15