E
evoxfan
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!
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!