Adding the last number in two columns

[adam73647]

I have two columns that have a value that changes each day. For instance Column A could look like this.

321
325
423
513
203

Column B would also have numbers that change in it each day. I would like to add the total of the last number entered. Currently I have my cell that I change every single day to reflect the new total of the columns. =SUM(D34+I34)

Is there a way to get that to update automatically?

[daddylonglegs]

Try this formula

=LOOKUP(9.9E+307,D:D)+LOOKUP(9.9E+307,I:I)

[adam73647]

Solved. Thanks!

:bowdown:

Care to explain what that means?

I get the D:D and the + I:I part. I don't know what the 9.9E+307 part of the formula is though, or how it knows the last entered value in that column.

[daddylonglegs]

9.9E+307 is a very large number - (almost) the largest that excel allows (9.9 with 307 zeroes). When you use "Bignum" as a lookup value that number isn't found so the number returned is always the last number in the range