View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default EXCLUDE TOTAL FROM FILTER

In your below query you have asked that you want to do sum for the data when
it is in Auto Filter, So first apply Autofilter and put the subtotal formula
to get the visible cells total.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



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