Originally Posted by math4043
Hi
I have a list of prices, a list of quantitys and a list for totals all in colums next to each other.
I want to multiply the qualtity by the prices and put the value in totals box.
I can use the sum button when they are highlighted but it only lets me add them up and has lots of other complex formulas, I cant find the simple mathmatical ones like multiply!!!
Help, you think the basic formulas would be on the sum button.
Can anyone help me???
thanks
mat
A1=QUANTITY
B1=PRICE
C1=TOTAL
This is the calculation to put in the totals cell C2
=SUM(A2*B2)
If you hover the mouse over the bottom left hand corner of the cell C2 untill it is a bold cross
+ then drag the column down it will replicate the formula in relation to the cells to the left.
PC Help Forum
» Software
» Office Software
»
[Answered] Ms Excel is to hard!!!
[Answered] Ms Excel is to hard!!!
Linear Mode
