Combining SUMIFS and SUMTOTAL

[Roo1799]

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!

 

[Roo1799]

Sorry my mistake, it was the slicer causing the problem.

Thanks for your help!!

 

[Fluff]

You're welcome & thanks for the feedback.