View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dickharlo@gmail.com is offline
external usenet poster
 
Posts: 3
Default mixing SumIf and Subtotal Functions

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