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! |
AutoSum/Subtotal Inclusions/Exclusions
Either copy the value of the formula somewhere before you un-filter (either
manually, or through a macro) or, if you're only filtering the one criteria, why not use: =SUMIF(A3:A53,"True",F3:F53) (I'm assuming column A contains true/false criteria) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "evoxfan" wrote: 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! |
AutoSum/Subtotal Inclusions/Exclusions
CopyPaste SpecialValuesOKEsc is the only way I can think of without
using a formula that doesn't include Subtotal function. =SUMIF(I3:I53,"True",F3:F53) Or if True or False are formula-derived you can remove the quotes =SUMIF(I3:I53,TRUE,F3:F53) Gord Dibben MS Excel MVP On Tue, 29 Sep 2009 09:58:01 -0700, evoxfan wrote: 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! |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com