Question

2. The numbers in Columns A and C are the factors of the numbers in
Column B.Match the columns.
Column A 1 Column B Column C
18
60​

Answer 1

Answer:

Step-by-step explanation:columns or rows of numbers, and then add up the results of individual calculations, use the SUMPRODUCT function to multiply cells and sum products.

Supposing you have prices in column B, quantity in column C, and you want to calculate the total value of sales. In your math class, you'd multiply each Price/Qty. pair individually and add up the sub-totals.

In Microsoft Excel, all these calculations can be done with a single formula:

=SUMPRODUCT(B2:B5,C2:C5)

If you wish, you can check the result with this calculation:

=(B2*C2)+(B3*C3)+(B4*C4)+(B5*C5)

And make sure the SUMPRODUCT formula multiplies and sums perfectly:

A formula to multiply and sum in Excel