Need help with Auto Filter

[Guest]

I have a spreedsheet that is filtered in multiple columns. I am running a
"Subtotal" function to count certian rows when I filter the column. My
question is this. Is there a way to save or freeze the data that the
subtotal function counts in a different cell. In other words I want subtotal
to count everything in a particular column but I want to be able to save that
number somewhere so that when I filter again with another variable I am able
to still view the first subtotal to compare the two. I hope this makes
sense and thanks in advance for any assistance you can provide.

 

[Guest]

two ways copy and paste special value
or if you want to leave the cell where it is
select the cell and use F9 to change it to a value

 

[Guest]

Hi jl-

You might want to take a look in Excel Help re Scenarios and/or Custom Views.

HTH |:>)