View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stgeorge Stgeorge is offline
external usenet poster
 
Posts: 3
Default Sum of visible cells only

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?