This will sum the quantities, per row, for all rows in the range.
Formula
=ARRAYFORMULA(SUMIF(IF(COLUMN(C2:E4),ROW(C2:E4)),ROW(C2:E4),C2:E4))
Screenshot
Example
I've created an example file for you: Sum over rows
Reference
https://stackoverflow.com/a/21804838/1536038
Answer from Jacob Jan on Stack ExchangeThe Bricks
thebricks.com › home › resources › how to multiply two columns in google sheets
How to Multiply Two Columns in Google Sheets - Bricks
April 22, 2025 - Select the Second Cell to Multiply: Click on cell E2 (the first cell in the "Price Per Unit" column). ... Press Enter. Google Sheets will calculate the product of the two cells and display the result in F2.
Google Support
support.google.com › docs › answer › 3094294
SUMPRODUCT - Google Docs Editors Help
The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges. Sample Usage SUMPRODUCT(A2:C5,D2:F5) SUMPRODUCT({1,2,3,4},{5,6,7,8}) Syntax
Sum the product of every two columns in the same row - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
Sum the product of two columns in Google Spreadsheets - Web Applications Stack Exchange
Here's the situation: ITEM COST CUST1 CUST2 CUST3 TQTY foo $0.5 1 0 0.5 1.5 baz $1.0 2 1 0 3 bar $1.5 0.5 0 0.3 0.8 SUBT $2.75 $1.... More on webapps.stackexchange.com
Question: Multiplying two columns
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
2
1
December 14, 2022I want to multiply the numbers in one column by the numbers in the next column - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
07:02
How To Do Multiplication In Google Sheets - The 4 Best Ways! - YouTube
01:38
How to multiply columns in Google Sheets - YouTube
02:49
Google Sheets: How To Use the Multiply Formula - YouTube
02:08
How To Multiply Cells In Google Sheets - YouTube
01:49
How to Multiply Two Columns in Google Sheets - YouTube
01:32
How to multiply two columns using the array formula - YouTube
Stack Overflow
stackoverflow.com › questions › 42286974 › how-to-have-2-columns-in-google-sheets-auto-multiply
How to have 2 columns in google sheets auto multiply? - Stack Overflow
If you have 2 columns A and B, and you want the multiplied value in column C, enter =A1*B1 into the C1 cell (don't forget the = sign). Then drag the bottom right corner of C1 down to match the height of your A/B columns.
Alphr
alphr.com › home › how to multiply two columns in google sheets
How to Multiply Two Columns in Google Sheets
December 1, 2021 - For a formula in Google Sheets to work, it should have some signs you have to remember. The first one, which is the basis of every formula, is an equality sign (=). For your formula to be valid and to show numbers, write this sign at the beginning. Next, to multiply numbers, you’ll use an asterisk sign (*) between them. Finally, to get the sum and complete your formula, press ‘Enter.’ · To multiply two columns in Google Sheets, you’ll first have to insert data.
Google Support
support.google.com › docs › thread › 246637585 › sum-the-product-of-every-two-columns-in-the-same-row
Sum the product of every two columns in the same row - Google Docs Editors Community
December 2, 2023 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
How-To Geek
howtogeek.com › home › web › how to multiply numbers in google sheets
How to Multiply Numbers in Google Sheets
October 30, 2019 - It fills in the remaining cells with the formula and the results. Double-click the little blue square, and, like magic, the rest of the table is filled in with the product of the two numbers.
Top answer 1 of 2
4
This will sum the quantities, per row, for all rows in the range.
Formula
=ARRAYFORMULA(SUMIF(IF(COLUMN(C2:E4),ROW(C2:E4)),ROW(C2:E4),C2:E4))
Screenshot
Example
I've created an example file for you: Sum over rows
Reference
https://stackoverflow.com/a/21804838/1536038
2 of 2
1
The right function to use is SumProduct
Formula
=SUMPRODUCT(array1, [array2, ...])
Screenshot
Excel Insider
excelinsider.com › home › our blog › google sheets formulas › how to multiply columns in google sheets (3 simple ways)
How to Multiply Columns in Google Sheets (3 Simple Ways) - Excel Insider
September 2, 2025 - We’ll use this dataset to apply and practice the different methods for multiplying columns in Google Sheets. The most basic way to multiply two columns in Google Sheets is by using the asterisk symbol *, which represents multiplication.
Tech Junkie
techjunkie.com › web › google sheets
How to Multiply Column by Constants in Google Sheets - Tech Junkie
September 4, 2021 - Type the same formula you’d use for multiplying. Here, it’ll be ‘=B4:B7*C4:C7.’ · Now, hold Ctrl + Shift + Enter, or Cmd + Shift + Enter for Mac users. Google Sheets will automatically add an array formula.
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to multiply in google sheets and excel
How To Multiply in Google Sheets and Excel
February 9, 2024 - To multiply in Google Sheets and Excel, use the equal sign followed by a multiplication formula. After all, most people use Google Sheets for two basic purposes — creating a record database or doing simple calculations, such as multiplying cells or columns.
Layer
golayer.io › home › how to multiply in google sheets (+ examples)
How to Multiply in Google Sheets (+ Examples) | Layer Blog
July 17, 2024 - The MULTIPLY function can only multiply two scalar values, so it is much more limited than PRODUCT. The syntax for MULTIPLY is as follows: MULTIPLY(factor1,factor2). The values of the factors can be cell references, or they can be typed directly ...
Superjoin
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
June 10, 2024 - Type = to start the formula. Enter the first number you want to multiply. Type * (the multiplication symbol). Enter the second number you want to multiply. Press Enter. For example, to multiply 3 by 8, you would type =3*8 and press Enter.
SimpleSheets
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
January 21, 2026 - To multiply two full columns, use =ARRAYFORMULA(A2:A*B2:B). ... Multiplication is one of the first things anyone needs from a spreadsheet, and Google Sheets gives you more ways to do it than most people realise.
InfoInspired
infoinspired.com › home › google docs › spreadsheet › multiply every two columns in google sheets – array formula guide
Multiply Every Two Columns in Google Sheets – Array Formula Guide
August 12, 2025 - Learn how to multiply every two columns in Google Sheets and sum the results per row using BYROW+LAMBDA or MMULT, with methods to hide zero results and boost performance.
Coefficient
coefficient.io › home
How to Multiply in Google Sheets: A Step-by-Step Guide
September 2, 2025 - To learn how to multiply two cells ... simply select the cells you want to multiply, type an equal sign (=), and then type the first cell reference you want to multiply, followed by an asterisk (*), and then the second cell reference you want to multiply...
Layer Blog
blog.golayer.io › google sheets › how to multiply in google sheets (+ examples)
How to Multiply in Google Sheets (+ Examples) | Layer Blog
June 26, 2023 - The MULTIPLY function can only multiply two scalar values, so it is much more limited than PRODUCT. The syntax for MULTIPLY is as follows: MULTIPLY(factor1,factor2). The values of the factors can be cell references, or they can be typed directly ...
Price: $
Address: La Marina de Valencia Muelle de la Aduana, 46024
LiveFlow
liveflow.com › product-guides › how-to-use-sumproduct-formula-in-google-sheets
How to Use SUMPRODUCT Formula in Google Sheets | LiveFlow
The SUMPRODUCT function in Google Sheets multiplies corresponding values in two or more arrays and returns the sum of those products.
Reddit
reddit.com › r/googlesheets › question: multiplying two columns
r/googlesheets on Reddit: Question: Multiplying two columns
December 14, 2022 -
How do I multiply two columns of data? I’ve tried to MMULT matrix multiply but it requires 1 column and 1 row of data
Top answer 1 of 2
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 2
1
multiply them and then add up the result? where are you looking to show the output?
Google Support
support.google.com › docs › thread › 204257010 › i-want-to-multiply-the-numbers-in-one-column-by-the-numbers-in-the-next-column
I want to multiply the numbers in one column by the numbers in the next column - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Lifewire
lifewire.com › multiply-in-google-spreadsheets-3123883
Create a Formula in Google Sheets to Multiply Numbers
November 29, 2022 - Learn how to multiply two or more numbers in Google Spreadsheets using a simple formula and the ArrayFormula function with a step-by-step example.