# Excel: How to Multiply Two Columns and then Sum

You can use the SUMPRODUCT function in Excel to multiply the values between two columns and then calculate the sum.

For example, you can use the following syntax to multiply the values between the ranges B2:B12 and C2:C12 and then calculate the sum:

```=SUMPRODUCT(B2:B12, C2:C12)
```

The following example shows how to use this formula in practice.

## Example: Use SUMPRODUCT to Multiply Two Columns and then Sum

Suppose we have the following dataset in Excel that contains information about the price of various products and total number of units sold by some company: Suppose we would like to calculate the total revenue for this company by multiplying the values between the Price and Units columns and then calculating the sum.

We can type the following formula into cell B15 to do so:

`=SUMPRODUCT(B2:B12, C2:C12)`

The following screenshot shows how to use this formula in practice: The formula returns a value of 761.

This represents the total revenue for the company.

We can confirm this is correct by manually multiplying the values between the Price and Units columns and then calculating the sum:

Total Revenue: (10*4) + (12*3) + (15*9) + (18*5) + (20*5) + (22*4) + (10*10) + (8*12) + (5*3) + (5*5) + (9*4) =761.

This matches the value calculated by our SUMPRODUCT formula.

Note: You can find the complete documentation for the SUMPRODUCT function here.