Thread: Filtering in Excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Filtering in Excel 2007
Keep the total above the filter and do not use SUM but SUBTOTAL


--


Regards,


Peo Sjoblom


"Kathy" <Kathy @discussions.microsoft.com wrote in message
...
How can I filter but keep a total line intact?


Reply With QuoteReply With Quote