ICloud – Linking between tables in Numbers

icloudiworknumbers

I have a table in numbers, and I want a cell to equal the value of a cell in a different table. Following the advice of this Apple discussion, I tried

=Units Sold::B2

, with Units Sold being the table with the value I wanted, and B2 being the value I wanted in the table "Units Sold".

enter image description here

To clarify, I want D2 of "Juice and Beverages" to equal the value of B2 of "Units Sold".

What am I doing wrong? Numbers for iCloud gives the error

The formula contains an invalid reference.

Thanks!

Best Answer

It does work in iCloud Numbers:

Select the cell you want the result in: i.e D2 of "Juice and Beverages"

And then in the text field at the top of the page enter:

=SUM('Units Sold' :: B2)

Take note of difference in how I have written it and how you did. Which was you main problem.

enter image description here

When done, click the green tick button on the right. And you will see this as the end result.

enter image description here

You can see some documentation on some of the included Functions by clicking into a cell and then into the:

1, text filed above:

2, you can search for a formula.

3,insert a Function template into the text field.

4, see a description of the Function and scrolling down further in the description you will see examples.

enter image description here

Related Question