Hi, I am currently on a drilling rig an a colleage would really like to run a formulae as a manual version has caused a problem that we dont want to happen again. I will try and describe the scenario and any help would be appreciated, I guess its a fairly basic question but I not too sure of the formula format required.
Say we have a number in cell A1 where the value of that number is 1000.
Say the user enters enters a number in cell A2 of 1200.
I would like to put a formula in cell A50 that says take the value of A1 and A2 and add the numbers together and display the answer in cell A50. I can do this but where I get stuck is with the following bit.
The user at certain time intervals will need to add the next reading in the next available cell down, the next number would go in Cell A3. The intent is that cell A50 would always reflect the next cell downs value plus whatever was in cell A1 which does not change.
So running through currently A50 is showing 2200, if the user enters 1500 in cell A4 then A50 would automatically update to 2500, if the user then enters 1800 in cell A5 then A50 would read 2800.
Any help greatly appreciated.
Thanks
Bookmarks