I'm trying to combine SUBTOTAL with SUMIFS using SUMPRODUCT but the formula is returning zero and I cannot figure it out!

=SUMPRODUCT(SUBTOTAL(9,OFFSET(Fcst_scenarios!I2,ROW(Fcst_scenarios!I:I)-ROW(Fcst_scenarios!I2),0)),(Fcst_scenarios!AB:AB=AT!C12)&(Fcst_scenarios!A:A=AT!D9)+0)

Sum values are coming from Fcst_scenarios Column I

The 2 criterias to meet are in cell AT!C12 & AT!D9 - with the range being in Fcst_scenarios Column AB and A.

Currently this formula is only working if I take out the second criteria "&(Fcst_scenarios!A:A=AT!D9)"

The data is linked to slicers hence the need for a SUMTOTAL.

Any help would be greatly appreciated!

Thanks!