» Summing Total Sales, Based on Quantity & Price

Problem:

Calculating the total sales price of all the items listed in column A, based on the amount of items sold (column B), and the price per unit (column C).

Solution 1:

Use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT(B2:B5,C2:C5)

Solution 2:

Use the SUM function as shown in the following Array formula:
{=SUM((B2:B5)*(C2:C5))}