Hi,
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!
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!