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!

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!

I may be missing something, but my best guess is in B12 you want:
=sum(b16:b35)

Regards
Fred

"Fernando@Sartorius" wrote in
message ...
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!

I am going to give this a shot. Thanks for the quick response. I will let you
know.

"JLatham" wrote:

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!

Unfortunately it is summing up the totals in B which I forgot to specify it
should not do. I apologize on that. I just need it to grab the last nomber
value on that B colum to display in B12.

"JLatham" wrote:

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!

No Fred. I want B12 to be the value of B16 on Feb. 1st after B16 sums up
C16+D16+E16. The total of that sum is the value of B16. I want B16 to updat
eB12.

The next day, Feb 2nd, I want B12 to get the number from B17 which will be
the Sum of C17 D17 E17... and that's how it is every day. I just want B12 to
automatically update with the value of those B cells, with out summing them,
just to put the value of the farther number down column B.

"Fred Smith" wrote:

I may be missing something, but my best guess is in B12 you want:
=sum(b16:b35)

Regards
Fred

"Fernando@Sartorius" wrote in
message ...
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!

.

If its this ...
.. just need it to grab the last number value on that B colum to display in B12
Try in B12: =LOOKUP(2,1/(B16:B35<""),B16:B35)
Amend the range monitored to suit. Joy? zonk the YES below
--
Max
Singapore
---

You are on the right idea, the lookup command is not working for some reason.
I copied to B12: LOOKUP(2,1/(B16:B35<""),B16:B35) and that is what it's
being displayed. It did not run a formula.

"Max" wrote:

If its this ...
.. just need it to grab the last number value on that B colum to display in B12
Try in B12: =LOOKUP(2,1/(B16:B35<""),B16:B35)
Amend the range monitored to suit. Joy? zonk the YES below
--
Max
Singapore
---

Ahh, did you forget the equal sign "=" ? It should have worked as well for
YOU as it did for me. If it's not the equal sign issue, then it sounds like
you were hit with another problem over there, that of your B12 being
pre-formatted as TEXT (unknown to you but of course). Just re-format B12 as
either general or number (via FormatCells), then click inside the cell B12,
re-confirm the formula to trigger it. You need to *re-confirm* the formula,
merely re-formatting the cell will NOT trigger it. Satisfy yourself that it
works well. Then go back to the earlier response, do some justice there by
re-rating it correctly. My exacting QC standards require that only thoughts
which work/help get posted.
--
Max
Singapore
---
"Fernando@Sartorius" wrote:
You are on the right idea, the lookup command is not working for some reason.
I copied to B12: LOOKUP(2,1/(B16:B35<""),B16:B35) and that is what it's
being displayed. It did not run a formula.

No, the = sign is there. I am still trying to figure out where the problem
resides.

"Max" wrote:

Ahh, did you forget the equal sign "=" ? It should have worked as well for
YOU as it did for me. If it's not the equal sign issue, then it sounds like
you were hit with another problem over there, that of your B12 being
pre-formatted as TEXT (unknown to you but of course). Just re-format B12 as
either general or number (via FormatCells), then click inside the cell B12,
re-confirm the formula to trigger it. You need to *re-confirm* the formula,
merely re-formatting the cell will NOT trigger it. Satisfy yourself that it
works well. Then go back to the earlier response, do some justice there by
re-rating it correctly. My exacting QC standards require that only thoughts
which work/help get posted.
--
Max
Singapore
---
"Fernando@Sartorius" wrote:
You are on the right idea, the lookup command is not working for some reason.
I copied to B12: LOOKUP(2,1/(B16:B35<""),B16:B35) and that is what it's
being displayed. It did not run a formula.

The issue could also lie with your actual data range. Does it contain white
spaces masquerading as "blanks"? Use TRIM to clean it up. Post back further
with your findings. In the interim you could easily test/prove to yourself
that it works on a clean new sheet
--
Max
Singapore
---
"Fernando@Sartorius" wrote:
No, the = sign is there. I am still trying to figure out where the problem
resides.