Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSum/Subtotal Inclusions/Exclusions
In column "I" I have either "True" or "False" in each cell.
I use autofilter and filter so that only "True" values are showing. In Cell I55, I have a formula (=SUBTOTAL(109,F3:F53)) to sum all values in Column F while the filter is applied and the formula works great. However when I remove the filter my formula now includes all the values that were once hidden. Any suggestions on how to prevent this from happening so that it does not include previously hidden values when my filter is removed? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make AutoSum really Sum, not Subtotal | Excel Worksheet Functions | |||
Autosum button performing subtotal | Excel Discussion (Misc queries) | |||
COUNTIF using exclusions | Excel Worksheet Functions | |||
COUNTIF using exclusions | Excel Worksheet Functions | |||
Formula Exclusions? | Excel Discussion (Misc queries) |