Remember Me?

#1
March 6th 21, 07:39 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2021 Posts: 2
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
March 6th 21, 07:42 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2021 Posts: 2
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Royzer Excel Programming 10 August 30th 12 08:55 PM noname Excel Worksheet Functions 6 March 22nd 12 08:05 PM sot Excel Programming 1 November 23rd 09 11:21 PM Father Guido[_5_] Excel Programming 0 November 19th 05 09:52 AM quality831 Excel Discussion (Misc queries) 1 April 22nd 05 02:42 PM

All times are GMT +1. The time now is 08:32 AM.