I'm wondering if I can combine a sumifs statement with a filter I've applied? In the case of totals for example, I know to find the sum of all visible rows I have to use the subtotal formula rather than the sum formula.
Similarly I'm wondering if there's something I can do for a sumifs? I want to get the sum of smth matching various criteria, which is where the sumifs comes in - but then I'd like to be able to apply manual filters and have the sumifs result change accordingly. Can that happen?
Similarly I'm wondering if there's something I can do for a sumifs? I want to get the sum of smth matching various criteria, which is where the sumifs comes in - but then I'd like to be able to apply manual filters and have the sumifs result change accordingly. Can that happen?
