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...
the best way is to convert your range into table then go to the table option and select total row, it will not effect the filter as well, try it and tell me what happen ?tmoerke