View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ket
 
Posts: n/a
Default Data Filter and AutoSum

Hello,

I have a column of figures in a spreadsheet that has data filters
applied to it.
This column of numbers is Autosummed at the bottom.

If I choose one of the data filters, it will collapse my column of
numbers accordingly. How do I continue to show the autosum total for
this filtered data set?

Hope this is clear and thanks in advance.

Ket
London