Google Sheets how to multiply two columns
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Steps
-
1
Enter =A1*B1 in the result cell.
-
2
Fill down the column.
-
3
Use ARRAYFORMULA for one-shot column math.
Related tutorials
These videos might help you go deeper on this topic.
Combine 2 Columns into 1: First Names and Last Names Together
Related blog posts
Written guides that go deeper on this question.
Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas
You may be using Google Sheet to do math and find that you need to iterate a number. ROW() gets you the row you're on, and helps you with this.
Read post →How to create a formula for every row in a column in a Google Spreadsheet?
3 possible ways to create a formula for every row in a column in a Google Spreadsheet. And two bonus ways to make it look nicer. - Auto fill - Double Click - ArrayFormula
Read post →Why Should I Code in Google Sheets?
Automate repetitive tasks, such as data entry, calculations, and formatting in Google Sheets.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Absolute reference ($)
Absolute references lock row, column, or both with dollar signs so a formula keeps pointing at the same cell when you...
Open →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once....
Open →Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →ARRAYFORMULA()
Google Sheets ARRAYFORMULA() function guide
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →MULTIPLY()
Google Sheets MULTIPLY() function guide
Open →Related questions
How to multiply two columns in Google Sheets
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Get the answer →How to multiply two cells in Google Sheets
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Get the answer →How to multiply columns in Google Sheets
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Get the answer →How to multiply multiple cells in Google Sheets
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Get the answer →How to multiply numbers in Google Sheets
Multiply with =A1*B1 or =MULTIPLY(A1, B1). For a whole column times a constant, use =ARRAYFORMULA(A2:A*C1) with an absolute reference on the constant when needed.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.