View Single Post
  #3   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

Try this€¦

Use subtotal.

For example:-
=SUBTOTAL(9,B2:B4)

Change the Range B2:B4 to your desired cell range.

If this post helps, Click Yes!

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



"Dave" wrote:

Hi

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

Can this be done??