I am trying to make a spreadsheet and set up some formulas for a workout routine. I am wanting to multiply a percentage of all the entries in row A (lbs) by Column B (.60). I have tried doing the copy and drag from "=SUM(B1*A2)" thru =SUM(B1*A63) but it increases the B1 part by 1 each time.
I have tried it on Google Docs and OpenOffice and it does the same thing. What am I doing wrong? I will also make a column for .67 and .78 so I don't want to have to enter the formula in each cell.
I have tried it on Google Docs and OpenOffice and it does the same thing. What am I doing wrong? I will also make a column for .67 and .78 so I don't want to have to enter the formula in each cell.
Comment