Q: Pages, formulas between multiple tables

You cannot multiple a Rate/hr. text field times a number field, so fixed Table 1::C2:C5 to be numeric. So set the formula as follows, and dragged the yellow grip from Table 1::D2 down to D5.

Same issue with table 2 where you are attempting to multiply a text mileage field times a numeric miles. Made mileage rate column numeric.

The hours Line Totals formula is:

Mileage formula:

And Totals:

You can not link across tables in Pages, for that you need to use Numbers.

What you can do is make a single table that appears to be multiple tables by setting the lines in the cells between to None.

Peter

"You can not link across tables in Pages, for that you need to use Numbers."

Seems to work fine here. Three separate tables. Formulas on Tables 1 and 2 reference only cells on their own table.

Formulas on Table 3 total amounts on Table 1 and on Table 2.

Formulas:

Table 1:: D2, filled down to D5: =B2×C2

Table 2::E2, filled down to E4: =Mileage×Rate

Expressed using addresses rather than column labels: =BxC

Table 3::B2: =SUM(Table 1::Amount)

Table 3::B3: =SUM(Table 2::Amount)

Table 3::B4: =SUM(B1:B2)

To keep the illustration simple, I haven't taken the step of rounding each result to two decimal places, or of formatting the money results as currency.

Regards,

Barry

Well that's something new!

Wonder when they did that?

At last, an actual improvement!

Peter

Sneaked it in when we weren't paying attention.

Probably around the time when Named tables became available, seeing as the tablename is a required part of the reference to a cell on a table other than the one containing the formula.

Barry

Well, it's a good thing!

At last something positive I can add to the checklist.

Peter

One can perform intra-table references in Pages '09. Observe table 3 referencing the sum of Line Totals for Hours from Table 1, and the sum of Extension for Mileage from Table 2. The key to this capability is using unique table headers on those tables (columns) that you wish to reference from another table.

In Pages '09 v4.3, one cannot reference another table cell range as table 1::D2:D4 to get the Line Totals for Hours. Simply reference the table column heading name. And it is the same for Mileage too.

Hours

Mileage