Hi,

Posting some sample data is usually helpful but I think you mean you want to
sum visible cells in filtered range in F18 - F99 where C18 - C99 is
management. Is that right?

Try this

=SUMPRODUCT(SUBTOTAL(9,OFFSET(F18:F99,ROW(F18:F99)-MIN(ROW(F18:F99)),,1))*(C18:C99="Management"))


Mike

" 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