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".
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!
Aucun commentaire:
Enregistrer un commentaire