Try a formula like this one in B12:
=INDIRECT("B" & COUNTA(B16:B65536)+15)

You can change the 65536 to some other large number. 65536 is the last row
number in Excel 2003. But if you know you'd only have, say 1 month's worth
of entries starting at B16, you could use B16:B46. Just make sure that
second B## row is large enough to capture all possible entries on the sheet
below B16.

Note that it assumes that nothing else is in column B below row 16 other
than the entries you are interested in.


"Fernando@Sartorius" wrote:

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!