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...
tmoerke Hi. I am loading this word document explaining step for step how I think you are trying to acheive your objective. It's totally different data, but it shows you how to get what I think is the result you are trying to acheive. Have a read and hope it helps.
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.
