Filtering in Excel 2007

[Kathy]

How can I filter but keep a total line intact?

 

[Peo Sjoblom]

Keep the total above the filter and do not use SUM but SUBTOTAL


--


Regards,


Peo Sjoblom