info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sum Data with Multiple Range = Multiple Range
14 views
Skip to first unread message
Ping_TH_Thamanart Tantisirivit
Mar 6, 2021, 1:39:56 AM3/6/21
to
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.
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.
Ping_TH_Thamanart Tantisirivit
Mar 6, 2021, 1:42:54 AM3/6/21
to
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?
=sumproduct(Table2!C1:C * (Table2!B:B={"Product x", "Product y"}) * Date range)
it works. Anyone can help to fix my syntax?
0 new messages