Need help updating 1 cell from other cells in same column
Hi and thanks in advanced for your attention. I am trying to do the following:
Have cell B12 be updated everyday automatically from 1 different cell when
data is found on those cells. Those cells contain a formula that sums 3 cells
in one same row. The total is of course put on those cells (B16 - B35).
To specify more on this problem let me give in that:
B16 represents the money earned on February 1st.
B17 represents the money earned on February 2nd
B18 the same for Feb. 3rd. and so on.
That data is only entered once per day. I tried link B12 to the value on
those cells, but it didn't work. Can anyone provide me any ideas or a
solution? Thank you!
|