Dear all,



I am struggling to find a solution to combine SUMPRODUCT and SUBTOTAL for a structured table.

I have a table with slicer, and I would like to get the SUMPRODUCT based on slicer selection.

By looking for a solution, I got this formula example:

=SUMPRODUCT(
SUBTOTAL(3,OFFSET('Raw Data'!F2:F150,ROW('Raw Data'!F2:F150)-ROW('Raw Data'!F2:F150),0)),
('Raw Data'!F2:F150=5)+0)


and I tried to apply this in my case. So, step by step:

ROW(BALANCE[TOTAL SAVINGS '[€'] MARCH 2024])-MIN(ROW(BALANCE[TOTAL SAVINGS '[€'] MARCH 2024])) ==> This Works
The next step is to apply the OFFSET function ==> now I am blocked

Could you help me?

Many thanks in advance