View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
Posts: 11,058
Default Keeping the total of filtered data

When you set up the AutoFilter, don't select the entire column or the head
cell. Just select the portion of the column you want filtered and the filter
wil leave the summary row alone.
Gary''s Student - gsnu200798

"Costas Limassol" wrote:

Hi there,

I have a list of data in columns and have added a total in each column at
the bottom row. When I filter my data my totals row disappears as well. I
tried defining my data, sum(), subtotal(9; ) but still the totals disappear.

I've read some similar questions and one solution is to place my totals
above the filtered area. This however does not fit the setup of my data so I
want the totals below the filtered data not at the top.

Does anybody have any ideas?