On Feb 21, 1:11*pm, Shane Devenshire
wrote:
Hi,

And here is another variation on the same theme

=SUMPRODUCT(SUBTOTAL(9,OFFSET(F18:F99,ROW(F18:F99)-18,,1))*(C18:C99="Manage*ment"))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire



" wrote:
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- Hide quoted text -

- Show quoted text -

don't see a 'Yes' button.....but thank you. Got it working....really
appreciate your help!!!