I am using autofilter in the data menu to filter data. When I use the
autosum icon, "=Subtotal()" automatically comes up in the cell. This is fine
until I change the filter, then it shows a different number until I go back
to the original filter get rid of all the filters. If I manually enter
"sum()" then I don't have the answer to the formula changing. I was
wondering if there is a way to get it to automatically enter "sum()" when I
am filtering and when I am click on the "Autosum" icon.