Keeping the total of filtered data

  • Thread starter Thread starter Costas Limassol
  • Start date Start date
C

Costas Limassol

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?
Thanks
 
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.
 
How about adding an empty row between the data and the total row?

And select the exact range you want filtered--don't include that empty row or
the total row when you apply the filter.
 
I've already tried that but for some reason it still does not work. Any
other ideas?
 
I've already tried that but for some reason it still does not work. I have
even named my range just to show exactly the area I indend to filter but no
luck either.

Any other ideas?
 
Just double checking...

You did remove the autofilter arrows and then select the exact range before you
reapplied data|filter|autofilter, right?
 
Yes, I did that. I even tried checking this on different PCs just in case
there was something wrong with my PC.

Unless I am doing something completely stupid then I am beginning to think
that it must be a bug of some sort.
 
I'd delete the total row.
Then reset the used range
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused

Then apply the filter.

Then add the total row after an empty row after the autofilter range.

Maybe it'll work???

Costas said:
Yes, I did that. I even tried checking this on different PCs just in case
there was something wrong with my PC.

Unless I am doing something completely stupid then I am beginning to think
that it must be a bug of some sort.
Click to expand...
 
Back
Top