View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default EXCLUDE TOTAL FROM FILTER

Perhaps make your data into a table and place the "subtotal" above the
table.

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