How to multiply multiple numbers from several cells in Excel There may come a time when you feel the need to multiply numbers that are situated in different cells.

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

To calculate the weighted average of this data set in Excel, follow these steps: Place your cursor in cell B9 (where the weighted average needs to be shown).

"C2:C15" identifies the multiple rows between cell C2 and C15; "D2:D15" identifies the rows between cells D2 and D15; "" means you want to multiply the content of each multiplied row together.