View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default EXCLUDE TOTAL FROM FILTER

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??