Hello Ken,
Thank you for the details of the issue you are experiencing with creating a formula that references a data in a different table. To reference the data in the different table, you will just need to click on the cell in the alternate table when building the formula:
Add, subtract, multiply, or divide values
You can create simple or complex arithmetic formulas to perform calculations on the values in your tables.
- Click the cell where you want the result to appear, then type the equal sign (=).The formula editor opens. Drag the left side of the formula editor to move it.
- Select a cell to use as the first argument in your formula, or type a value (for example, a number such as 0 or 5.20).
- Type an arithmetic operator (for example, +, -, *, or /), then select a cell to use as the next argument in your formula, or type a value.By default, + is inserted between cell references.
- Continue adding operators and arguments until your formula is complete, then press Return or click in the formula editor when you’re done.If you click , you exit the current cell without saving your changes.
In step 2, just click the cell from the alternate table to reference that cell in your equation.
Calculate values using data in table cells
http://help.apple.com/pages/mac/5.0/#/tana41710df7
Thank you for using Apple Support Communities.
Best,
Sheila M.