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?
I want to multiply the numbers in one column by the numbers in the next column - Google Docs Editors Community
How do I multiply with text in the cell?
I want to multiply two cells, but one of them has text mixed with numbers
How to multiply row by constant - google sheets - Stack Overflow
How can I multiply numbers from different sheets in Google Sheets?
What is the multiply formula in Google Sheets?
How do I multiply values based on a condition in Google Sheets?
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.I want to multiply D14 by E14 and I want the product to be shown in the H14 collumn
I want to start tracking my training with sheets to make a log of my training long term, I also want to be able to visualize my progress with a line graph, however the problem is that there are many metrics that I want the graph to be able to show, I dont want many graphs for all my stats, so first what I wanted to do is to mesh reps with weights on a score sistem that it would be basiclly the reps multiplied by the weight, that way if I increese weights but keep the same amout of reps or do more reps with less weight the graph will reflect my growth accordingly because instead of showing neither it will show the score of that day.
I dont know if thats the best way to go about it, im a noob in google sheets, so if you have any suggestions it would be gladly appreciated.
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)

In Excel or Google Sheets, multiplication should use the product formula. like
=product(A1:B1)
It will work.