• Sum Data with Multiple Range = Multiple Range

    From Ping_TH_Thamanart Tantisirivit@21:1/5 to All on Fri Mar 5 22:39:54 2021
    I have this data in 2 google sheet tables
    First table :
    | Product Group | Product |
    | -------- | -------------- |
    | Group A | Product x |
    | Group A | Product y |
    | Group B | Product z |
    | Group B | Product x |

    Second Table :
    | IV | Product | Revenue | Date |
    | -------- | -------------- |-------- | -------------- |
    | IV-01 | Product x | 10$ | 1 Jan |
    | IV-02 | Product y | 15$ | 2 Jan |
    | IV-03 | Product z | 25$ | 5 Jan |


    I need to sum value of my Revenue of Product Group A within Date Range 1-2 Jan. What formula should I do?
    I have tried
    =sumproduct(Table2!C1:C * Table2!B:B=filter(Table1!B:B,Table1!A:A = Product Group A) * Date range)
    But it doesn't work.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ping_TH_Thamanart Tantisirivit@21:1/5 to All on Fri Mar 5 22:42:52 2021
    But when i use this formula
    =sumproduct(Table2!C1:C * (Table2!B:B={"Product x", "Product y"}) * Date range) it works. Anyone can help to fix my syntax?

    On Saturday, March 6, 2021 at 1:39:56 PM UTC+7, Ping_TH_Thamanart Tantisirivit wrote:
    I have this data in 2 google sheet tables
    First table :
    | Product Group | Product |
    | -------- | -------------- |
    | Group A | Product x |
    | Group A | Product y |
    | Group B | Product z |
    | Group B | Product x |

    Second Table :
    | IV | Product | Revenue | Date |
    | -------- | -------------- |-------- | -------------- |
    | IV-01 | Product x | 10$ | 1 Jan |
    | IV-02 | Product y | 15$ | 2 Jan |
    | IV-03 | Product z | 25$ | 5 Jan |


    I need to sum value of my Revenue of Product Group A within Date Range 1-2 Jan. What formula should I do?
    I have tried
    =sumproduct(Table2!C1:C * Table2!B:B=filter(Table1!B:B,Table1!A:A = Product Group A) * Date range) '
    But it doesn't work.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)