You can also use the SUMPRODUCT formula to find the sum product of values that meets a specific condition. For example, in the below example we want to multiplication Sumproduct for two arrays but only for the product named ‘Oranges’. To do that, use the below formula: =SUMPRODUCT((B2:...