View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default EXCLUDE TOTAL FROM FILTER

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