Thread: How to Sum-If when the cells to sum are Auto-filter visable cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dennis
 
Posts: n/a
Default How to Sum-If when the cells to sum are Auto-filter visable cells?
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