Reference Footer Cell in Dynamic Table

One way to always reference the last row of an expanding table is to use the INDEX and ROWS functions, something like this:

=INDEX(B,ROWS(B))

So in your example you could do something like this:

In B2 you could put:

=INDEX(INDIRECT("Event Log::"&$A2&"::B"),ROWS(INDIRECT("Event Log::"&$A2&"::B")))

That works. HOWEVER:

• It's difficult to debug and maintain.
• It uses "volatile" functions that may make your document sluggish.
• Formulas cannot reference "multiple files."

Rather than have your event log data scattered across multiple tables, consider that there are HUGE advantages to keeping your data together in one table and using powerful features built into Numbers pull out summary data for you.

A simplified example:

You can easily change this to make it look more presentable. It took a minute or so to generate. Click in the table with the data, choose Organize > Create Pivot Table > On Current Sheet (or separate sheet if you want) in the menu and just drag the "fields" in the right panel to the boxes below.

Intro to pivot tables in Numbers on Mac - Apple Support

SG

Steve727 wrote:

I don't know that multiple tables and pivots are possible for this project

Not suggesting "multiple tables and pivots."

Am suggesting ONE table for like data and multiple filters and pivots that draw from that data.

I think you will find that MUCH simpler and easier and far less error-prone. It's generally a "best practices" approach, applicable to most projects where you have to wrangle a lot of data.

SG