Thread: How to Sum-If when the cells to sum are Auto-filter visable cells?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Domenic
 
Posts: n/a
Default How to Sum-If when the cells to sum are Auto-filter visable cells?
Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3:F26331,ROW(F3:F26 331)-ROW(F3),0,1)),--(F
3:F26331="-SPLIT-"),G3:G26331)

Hope this helps!

In article ,
Dennis wrote:

Using 2003

How can I change next below
=SUMIF(F3:F26331,"-SPLIT-",G3:G26331)

To effectively:

=SUMIF(F3:F26331,"-SPLIT-",Subtotal(9,G3:G26331))

In short, the items to sum will change as I select choices in the via
Autofilter.

TIA Dennis
Reply With QuoteReply With Quote