Do, a sum from the top cell to the very last cell at bottom. The result will
be based on the visible cells automatically. And the result will change
correspondly when you change the filter. Just make sure don't filter out the
the result.

"Stgeorge" wrote:

I have a large spreadsheet that I am using multiple drop downs in to sort for
different scenarios. I do not want to use the general data subtotal command
but each time I sort I want to get a total for the visible cells - how do you
do this?