I cannot figure out how to do this, I am hoping someone can give me some mega-super appreciated help!! I have a formula that I want to copy down the column. I want all the info in the formula to remail the same except that I want to add the next cell to it as I go down...how do I do this without having to manually change the info in each cell?!?!?
ex: =SUM(C2:C4)/SUM(B2:B4)
i want the cell below to read =(SUM(C2:C5)/SUM(B2:B5) and so forth
ex: =SUM(C2:C4)/SUM(B2:B4)
i want the cell below to read =(SUM(C2:C5)/SUM(B2:B5) and so forth