Home > Software engineering >  Google sheet Sumproduct with importrange of unique values
Google sheet Sumproduct with importrange of unique values

Time:06-07

I have data in two sheets (Source Sheet and Result Sheet). I want to import the unique values based on two columns of the source sheet into result sheet along with the product of two columns based on unique value. For more clarity I had entered test data in the Source Sheet with the expected outcome in the Result Sheet. The links of both the sheets are as below

Source sheet enter image description here

  • Related