Multiplying in Excel Using Multiplication Symbol To create a multiplication formula in an Excel cell, always begin the formula with an equal sign (=) and use the asterisk symbol (*) or the PRODUCT function to multiply numbers or cells. Using this method, you can easily multiply numbers, cells...
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:...