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?
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?