Grab the last values

[jltjr75]

I want the final total between both accounts added when I update the numbers quarterly. For example D9+I9 = B1
Where I will have the problem is when I add the next quarter to row 10 (then row 11,12,13...) Is there a formula that can grab the last values (D10+I10) and = it in B1?
I would like this to continue as I add future quarters automatically.

 

[Rick Rothstein]

One way...

=LOOKUP(9E+99,D:D)+LOOKUP(9E+99,I:I)

although it would be more efficient if you could establish a small maximum range such as...

=LOOKUP(9E+99,D1:D999)+LOOKUP(9E+99,I1:I999)

 

[jtakw]

Hi,

=LOOKUP(9.99999999999999E+307,D5:D200)+LOOKUP(9.99999999999999E+307,I5:I200)

although it would be more efficient if you could establish a small maximum range such as...

=LOOKUP(9E+99,D1:D999)+LOOKUP(9E+99,I1:I999)

Edit: I used 200, I figured since we're doing Quarterly, that's nearly 50 years worth of rows

 

[Rick Rothstein]

@jtakw,

Our formulas are the same except that you opted to use the "correct" number (9.99999999999999E+307) instead of my number (9E+99). I hate typing long formulas and figured that since the OP was working with money values, a number with 99 digits would always be larger than any dollar amount the OP would have. As for using 200 or 999... I find typing the same digit easier than using differing digits... once we assume three digits, I almost automatically use repeated 9s.

 

[jtakw]

I pointed out using 200 strictly for the humor factor, nearly 50 years worth, but OP can use whatever he wants.
As for the dollar amount, he "could" be Jeff Bezos or Elon Musk in disguise

 

[Rick Rothstein]

As for the dollar amount, he "could" be Jeff Bezos or Elon Musk in disguise

Even they are not that rich!

 

[jltjr75]

Thank you both. I've studied the formulas and they seem easy enough. I'll add them to my toolbelt. I did change numbers for this forum but I'm no Jeff Bezos or Elon Musk