Here goes!!! I am attempting to write the following formula: =sum(e1:e1) then I would like to copy this down so that the next cell reads as =sum(e1:e2) and then so on and so on so that eventually I have 5000 rows and the final formula would be =sum(e1:e5000). However, if I try and drag down the first formula, both numbers change whereas I want the first E1 to remain the same and only the second E1 should go up and up until it reaches E5000.
HELP!!! I hope this makes sense. I can't believe that there is not a solution to this as so far the only solution I have is to copy it down then go into the formula 4999 times and change the first number back to E1!!!!
Thanks!!! I should warn you in advance that I'm not a whizzkid on Excel so laymans terms would be greatly appreciated!!!
HELP!!! I hope this makes sense. I can't believe that there is not a solution to this as so far the only solution I have is to copy it down then go into the formula 4999 times and change the first number back to E1!!!!
Thanks!!! I should warn you in advance that I'm not a whizzkid on Excel so laymans terms would be greatly appreciated!!!
