dimanche 1 février 2015

Linking between tables in Numbers


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!





Aucun commentaire:

Enregistrer un commentaire