You can put in row 4:
=ARRAYFORMULA(B2:Z2*B3:Z3)
This will expand to the whole row. Adapt B and Z to the columns you need!
If you can omit row 3, you can just use:
=ARRAYFORMULA(B2:Z2*0.09)
Google Support
support.google.com › docs › answer › 3093978
MULTIPLY - Google Docs Editors Help
Returns the product of two numbers. Equivalent to the `*` operator. Sample Usage MULTIPLY(A2,B2) MULTIPLY(2,3) Syntax MULTIPLY(factor1, factor2) factor1 - The first multiplicand
SimpleSheets
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
January 21, 2026 - Click the cell where you want the result. The pattern is an equals sign, the first number, an asterisk, then the second number. To multiply 9 and 2, type =9*2. The cell shows 18. The formula stays in the formula bar, so you can change either ...
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 More on support.google.com
How to multiply row by constant - google sheets - Stack Overflow
in Google Sheets. Row 1 are all labels. Column 1 are all labels. Both are locked. Row 2 has unique quantities. Row 3 is a constant of 0.09. I want to multiply all of row 2 by row 3, and have all More on stackoverflow.com
How to multiply an entire column by the value in a single cell? (I've included a pic to show what I mean) Is there an easier way than writing a formula in each individual cell? I've tried copying the formula from one but it only multiplies it by the cell above it, which isn't what I want.
Assuming your values for seafood (1, 2, 1 etc) are in A2:A, then in B2 use the formula =arrayformula(if(A2:A="",,A2:A*$B$1)) More on reddit.com
4
5
June 28, 2021im trying to multiply an entire colum by 1000 on sheets im not trying to create a new colum - 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
How can I multiply numbers from different sheets in Google Sheets?
To multiply numbers from different sheets, reference the sheet name and cell address in your formula. For example, if you want to multiply the value in cell A1 of Sheet1 by the value in cell A1 of Sheet2, you would use the formula =Sheet1!A1*Sheet2!A1.
superjoin.ai
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
What is the multiply formula in Google Sheets?
It is the asterisk. Type an equals sign, the first value, an asterisk, then the second value, for example =A1*B1. There is also a named function, =MULTIPLY(A1, B1), which does exactly the same thing but accepts only two arguments.
simplesheets.co
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
How do I multiply values based on a condition in Google Sheets?
You can use the SUMPRODUCT function for conditional multiplication. For instance, to multiply values in the range A1 that are greater than 5, you can use the formula =SUMPRODUCT((A1:A10>5)*A1:A10).
superjoin.ai
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
Reddit
reddit.com › r/googlesheets › efficient way of getting total with sum and multiply
r/googlesheets on Reddit: Efficient way of getting total with SUM and MULTIPLY
October 12, 2024 -
I have a sheet with column B amounts and D prices
For making a grand total and I made a extract of the following formula:
=SUM(MULTIPLY(B2,D2); MULTIPLY(B3,D3); MULTIPLY(B4,D4))
Can this be more efficient, without adding more rows in SUM?
Top answer 1 of 2
2
=SUMPRODUCT(B2:B4,D2:D4) Can just change the 4 to go to whatever row you want. If the cells below are empty you can even preset the range to include them ahead of time and then they will automatically be included as you fill in numbers.
2 of 2
1
u/RelevantLecture9127 Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”) to officially close your thread. Applying the “Solved” flair to the post without indicating a solution is actually a violation of the subreddit rules (see rule #6). Thank you in advance for resolving this issue!
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 - You can also multiply the values of two cells by referencing their cell addresses: Select the cell where you want the result to appear. ... Enter the cell address of the first value (e.g., A1). ... Enter the cell address of the second value (e.g., B1). Press Enter. For instance, if cell A3 contains the value 3 and cell B3 contains the value 8, the formula =A1*B1 would result in 24. Google Sheets also provides a built-in MULTIPLY function that allows you to multiply multiple values or cell references together:
W3Schools
w3schools.com › googlesheets › google_sheets_multiplication.php
Google Sheets Multiplication Operator
GS Sort GS Sort Sheet GS Sort By ... MEDIAN MIN MODE OR STDEV.P STDEV.S SUM SUMIF SUMIFS VLOOKUP XOR ... Multiplication uses the * symbol in Google Sheets....
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
LiveFlow
liveflow.com › product-guides › multiply-function-in-google-sheets
MULTIPLY Function in Google Sheets: Explained | LiveFlow
You can also use the =MULTIPLY formula to multiply the contents of cells. For example, if you have the number 2 in cell B4 and the number 3 in cell C4, you can enter the formula ... Sheets tutorials availalble now in our free certificate program!
Better Analyst
betteranalyst.com › home › google sheets formulas › how to multiply in google sheets
How to Multiply in Google Sheets | Formulas
Multiply cells in Google Sheets with the asterisk operator, PRODUCT, and absolute references for fixed rates.
Statology
statology.org › home › google sheets: how to multiply column by a percentage
Google Sheets: How to Multiply Column by a Percentage
February 4, 2022 - For example, to multiply by 90% simply use the following formula: ... Then click and drag this formula down to all of the remaining cells in column B. The following tutorials explain how to perform other common tasks in Google Sheets:
Top answer 1 of 2
1
You can put in row 4:
=ARRAYFORMULA(B2:Z2*B3:Z3)
This will expand to the whole row. Adapt B and Z to the columns you need!
If you can omit row 3, you can just use:
=ARRAYFORMULA(B2:Z2*0.09)
2 of 2
0
In Excel or Google Sheets, multiplication should use the product formula. like
=product(A1:B1)
It will work.
Trainn
trainn.co › tutorials › multiply-in-google-sheets
How to Multiply in Google Sheets? - Google Sheets Tutorials
June 26, 2025 - Here's an interactive guide and step-by-step walkthrough on how to multiply in Google Sheets.
Statology
statology.org › home › how to use a multiply if function in google sheets
How to Use a MULTIPLY IF Function in Google Sheets
July 19, 2022 - We can verify that this is correct by manually multiplying each of the points values together for the Mavs: ... This matches the value that we calculated using the formula. Note: You can find the complete documentation for the PRODUCT function in Google Sheets here.
Reddit
reddit.com › r/sheets › how to multiply an entire column by the value in a single cell? (i've included a pic to show what i mean) is there an easier way than writing a formula in each individual cell? i've tried copying the formula from one but it only multiplies it by the cell above it, which isn't what i want.
r/sheets on Reddit: How to multiply an entire column by the value in a single cell? (I've included a pic to show what I mean) Is there an easier way than writing a formula in each individual cell? I've tried copying the formula from one but it only multiplies it by the cell above it, which isn't what I want.
June 28, 2021 - 28K subscribers in the sheets community. Everything related to Google Sheets: Your sheets, best practices, questions, and discussions.
Google Support
support.google.com › docs › thread › 28343258 › im-trying-to-multiply-an-entire-colum-by-1000-on-sheets-im-not-trying-to-create-a-new-colum
im trying to multiply an entire colum by 1000 on sheets im not trying to create a new colum - Google Docs Editors Community
February 10, 2020 - 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
Reddit
reddit.com › r/googlesheets › trying to divide, multiply and then round in one cell?
r/googlesheets on Reddit: Trying to divide, multiply and then round in one cell?
March 27, 2024 -
Hi there.
I'm trying to divide a cell B6 with my total D6 and then multiply by 100 (to get a percentage) then i'd like to round that percentage 2 places...
=(B6/D6)*100,ROUND(b6,2)
That's what i'm TRYING to enter and of course it's now working...Can someone tell me how I would solve this? I've looked online how to combine multiple formula's in a cell but i'm not finding a solution.
Stack Overflow
stackoverflow.com › questions › 74750431 › in-google-sheets-how-do-i-multiply-a-duration-or-interval-constant
In Google Sheets, how do I multiply a duration or interval constant? - Stack Overflow
I'm making calculations on production cost (in number of resources) and duration. I have a process that takes 5 minutes. Using the Duration format, I would enter that as 00:05:00. I want to queue u...
YouTube
youtube.com › source › bsehSva8eTo › shorts
How to Multiply in Google Sheets
AboutPressCopyrightContact usCreatorsAdvertiseDevelopersTermsPrivacyPolicy & SafetyHow YouTube worksTest new featuresNFL Sunday Ticket · © 2026 Google LLC · How to Multiply in Google Sheets
Scribe
scribehow.com › viewer › How_to_Multiply_in_Google_Sheets__EKKEZhcFTXGytF0W4kMCbg
How to Multiply in Google Sheets | Scribe
This guide provides a straightforward approach to performing multiplication in Google Sheets, whether using direct numbers, cell references, or built-in formulas. It equips users with essential techniques to quickly calculate results, making it especially helpful for those working with dynamic ...
Reddit
reddit.com › r/googlesheets › how do i multiply with text in the cell?
r/googlesheets on Reddit: How do I multiply with text in the cell?
June 27, 2024 -
I have a column of time that goes like this - 23:05:47 (Hrs, Min, Sec). When the hours go over 24, the cell turns into days such as 2 days, 05:25:09. I need to convert the time into all minutes. So far, I have been making the column into plain text and then multiplying the cell by 1440 which works for the cells with no days. I have about 300 cells that have days, and it's too much to manually convert all of the days back into hours.
So, how do I make a cell like 5 days, 17:31:31 or 44 days, 16:03:00 into only minutes?
The 129 hrs is from converting the days into hours. Top answer 1 of 5
2
Seems like it works now. In column B: =if(istext(A2), if(REGEXMATCH(A2, " days, "), Split(REGEXREPLACE(A2," days",""),",",true), Split(REGEXREPLACE(A2," day","") ,",",true)),0) If there isn't a number in A, split the number of days from the rest (in two different ways depending on if it "day" or "days"). Othervise put a 0. In column D: =if(isnumber(C2),split(C2,":"),split(A2,":")) Split the numbers in either A or C, depending on where it is. In column D everything is added up. Note that seconds are rounded. Hope this helps.
2 of 5
1
u/jojododo1 Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified to officially close your thread. Marking your post as “solved” without indicating a solution is actually a violation of the subreddit rules (see rule #6).
Google Support
support.google.com › docs › thread › 174444118 › how-to-copy-paste-and-multiply-a-value-to-multiple-non-adjacent-cells
how to copy paste and multiply a value to multiple non-adjacent cells? - 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