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 know its too late to reply to your query however check and see if the cell next to the SubTotal formula is blank and is being selected when you use filter. I faced the same problem with my data in excel and it turns out that you also have to select the column or row which has the subtotal formula for it to show the result of your filter. I hope this helps.