Using Excel 2003 SP3 Professional Edition

I have a large spreadsheet that has a subtotal at the end of the data
(=subtotal(9,K4:K4000). I have many different values that I filter on that I
like to see the subtotal at the bottom of the filtered list. One day this
was working and the next day it wasn't. What is happening now is the
subtotal line is being hidden when the filter is on. Can anyone help me
figure out how to get it not to hide?