LinkBack URL
About LinkBacksUsing 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks