Table of Contents
To multiply two columns in Excel and then sum the resulting values, follow these steps:
1. Select a blank cell where you want the sum to appear.
2. Type the formula “=SUM(” without the quotation marks.
3. Select the first cell in the first column that you want to multiply.
4. Type the multiplication symbol “*” without the quotation marks.
5. Select the first cell in the second column that you want to multiply.
6. Close the parentheses “)” without the quotation marks.
7. Press Enter to complete the formula and get the sum of the multiplied values.
Excel: 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.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I multiply two columns in Excel and then sum the resulting values?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-multiply-two-columns-in-excel-and-then-sum-the-resulting-values/
stats writer. "How do I multiply two columns in Excel and then sum the resulting values?." PSYCHOLOGICAL SCALES, 22 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-multiply-two-columns-in-excel-and-then-sum-the-resulting-values/.
stats writer. "How do I multiply two columns in Excel and then sum the resulting values?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-multiply-two-columns-in-excel-and-then-sum-the-resulting-values/.
stats writer (2024) 'How do I multiply two columns in Excel and then sum the resulting values?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-multiply-two-columns-in-excel-and-then-sum-the-resulting-values/.
[1] stats writer, "How do I multiply two columns in Excel and then sum the resulting values?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I multiply two columns in Excel and then sum the resulting values?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.