Sum Filtered Cells - Keep Total Sum When Unfiltered

[Rinsa]

Hello,

I have taken over doing our data at work for a little while and noticed that the previous person would click+click to get a total of the summed cells when they were filtered.

I know that you can Subtotal Filtered Cells, but I have to unfilter the cells when I am done. Is there a way to keep the total sum of those cells when I unfilter?

 

[JimSnyder]

The easiest way I can think of is to copy the value to another cell before unfiltering.