View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default EXCLUDE TOTAL FROM FILTER

If you put the subtotal formula in the first available row after the
filtered data, then Excel will adjust the filter range to include that
row next time you filter.

You will need to leave at least one blank row between the bottom of
your data and your subtotal formula.

Alternatively, you can insert a new blank row at the top of your sheet
and put the subtotal formula on that row - it saves you having to
scroll down to the bottom everytime you change the filter setting.

Hope this helps.

Pete

On Oct 13, 1:43*pm, Dave wrote:
Hi

The only problem is when I filter the column, the row with the subtotal in
dissparears. How do i keep the row in the filter?

Thanks



"Mike H" wrote:
Hi,


Do you mean visible cells in a filtered column. If so use SUBTOTAL


=SUBTOTAL(109,B2:B8)


109 makes to sum only visible rows.


Mike


"Dave" wrote:


Hi


I am trying to create a row which will only sum whatever is in a filtered
columns.


Can this be done??- Hide quoted text -


- Show quoted text -