Subtotal not showing filtered out cells

I have subtotals to add up my columns but when I use my filter the subtotal does not include the hidden cells. Is there a way to include the hidden cells?

It's always best to include a sample file with your post, but one way to include hidden cells is to use SUM. You might also try =AGGREGATE(9,4,Array) (where the "4" says to ignore nothing.

Thanks Greg, I was able to solve it by replacing the Subtotal formulas with Sum. I was able to do it easily by using the find and replace function FIND:

=Subtotal(9,
Replace with: =Sum(

This kept all the data ranges I had in place with the Subtotal formula.

Thanks for your help.