SUMIFS with Subtotal

[benntw]

I am looking to combine SUMIFS and subtotal. I have tried to alter a sumproduct formula, but have not had any luck. I named my ranges to make the formula easier to write.

Wsum equals the range I am trying to sum, WT & Sch are my two criteria. Here is a sumproduct formula that works to find 1 criteria. Can anyone help to add two or more criteria ?

=SUMPRODUCT(SUBTOTAL(9,OFFSET(WSum,ROW(WSum)-ROW($H$10),0,1,1)),--(WT=P2))

Here is how I tried to modify the sumproduct formula

=SUMPRODUCT(SUBTOTAL(9,OFFSET(WSum,ROW(WSum)-ROW($H$10),0,1,1)),--(WT=P2),(Sch=O3)) . I even tried adding the - - between the two criteria. Hope someone has the answer to this. Thank you.

 

[Aladin Akyurek]

Like this:

=SUMPRODUCT(SUBTOTAL(9,OFFSET(WSum,ROW(WSum)-ROW($H$10),0,1,1)),--(WT=P2),--(Sch=O3))

 

[benntw]

Thank you. I wrote this one earlier and realized after I put yours I forgot to lock P$2 & $O3. I appreciate the help.