Forum Discussion
Excel subtotal command ignores filters
I have a simple range of rows and columns. The first column is department and another column is location. The rows consist of descriptions of projects taking place within a department at different lo...
I think you are missing our problem. When filtering, the subtotal, 9 does not change the sum to reflect what is being filtered (as would be expected).
Formulas tab, under calculation Options, switch to automatic. This solved my issue
Raerea It's already on Automatic.
