DGET I\'m making a spreadsheet in Excel 2004 ( Mac ). There are around a dozen c

Question

DGET

I'm making a spreadsheet in Excel 2004 (Mac). There are around a dozen columns, each corresponding to a bank acct, an IRA, a mutual fund balance, etc. They are updated more or less monthly, but not all on the same day of the month necessarily. To keep a running total of all accounts I would like to take all the bottom (most recently entered) figuresse and sum them. DGET allows me to pull a single figure from a column, but I can't find the criterion which designatess the bottom, or most recently entered figure. Or maybe there's a simpler way to accomplish this????   

Explanation / Answer

One way:

Assume your data is in B2:Bxxxx, with no gaps:

=INDEX(B2:B1048576, COUNT(B2:B1048576))

Or, if you have a header in B1, a bit shorter:

=INDEX(B:B, COUNTA(B:B))

Or, if you have a blank row 1:

=INDEX(B:B, COUNTA(B:B) + 1)

etc.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.