D
dickharlo
I have a sumif calculation: =SUMIF($C$18:$C$99,"Management",F18:F99)
I want to put filters in, and make the F18:F99 portion of the formula
a subtotal, rather than a full return. I tried putting Subtotal
(9,F18:F99) at the end of the above formula...but they don't mix well.
Is there a way to create subtotal based on filters...within a sumif
formula?
Thanks
I want to put filters in, and make the F18:F99 portion of the formula
a subtotal, rather than a full return. I tried putting Subtotal
(9,F18:F99) at the end of the above formula...but they don't mix well.
Is there a way to create subtotal based on filters...within a sumif
formula?
Thanks