| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Data with Multiple Range = Multiple Range
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum Data with Multiple Range = Multiple Range
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy range from multiple files in multiple folders to single sheet in master WB | Excel Programming | |||
| Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function | Excel Worksheet Functions | |||
| copying a range of data multiple times from multiple workbooks | Excel Programming | |||
| Creating Multiple GIFs from Multiple Range selections -- I need a volunteer to test my code to see why it fails | Excel Programming | |||
| Excel - Can i get a top 10 across a range of data in multiple wor. | Excel Discussion (Misc queries) | |||
Hybrid Mode
