#1
|
|||
|
|||
SUMPRODUCT and SUBTOTAL for STRUCTURED TABLE
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pivot table subtotal questions | sarana | Excel | 6 | 01-27-2019 08:22 PM |
Excel Structured Referencing: non-English reference? | tinfanide | Excel | 0 | 09-05-2015 04:41 AM |
Creating macros for a well structured analysis system | chillerlegend | Excel Programming | 1 | 06-21-2015 05:28 AM |
My subtotal and sum | Anmol786 | Excel | 1 | 01-18-2015 01:43 AM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |