Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy range from multiple files in multiple folders to single sheet in master WB Royzer Excel Programming 10 August 30th 12 08:55 PM
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function noname Excel Worksheet Functions 6 March 22nd 12 08:05 PM
copying a range of data multiple times from multiple workbooks sot Excel Programming 1 November 23rd 09 11:21 PM
Creating Multiple GIFs from Multiple Range selections -- I need a volunteer to test my code to see why it fails Father Guido[_5_] Excel Programming 0 November 19th 05 09:52 AM
Excel - Can i get a top 10 across a range of data in multiple wor. quality831 Excel Discussion (Misc queries) 1 April 22nd 05 02:42 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017