how to i use a value of a cell on another sheet

Question

Level 1

5 points

I need to post the value of a cell from a sheet to another sheet in numbers.

Here is the situation:

sheet 2, cel B28, needs to be displayed on sheet 1 in cel B15

I am using the Beta version of numbers on my icloud account.

any help would be great

thanks

FS

icloud/numbers beta-OTHER

Posted on Jan 2, 2014 8:36 AM

Reply

Answer 1

You specify a cell in a different sheet via sheet name, table name and cell reference.

For example, =Home::Table 1::C31 refers to cell C31 in Table 1 of sheet named Home.

Reply

Answer 2

Level 1

5 points

sorry I clicked on the wrong button..... This solved my problem... Thanks so much.

Would you be abole to tell me how to add several cell together from diffrent sheet????

Exemple

Cell B5 from sheet HOME

Cell B5 from sheet OFFICE

Cell B5 from sheet WAREHOUSE

Cell B5 from sheet COTTAGE

Thanks

FS

Reply

Answer 3

Place the following into the cell you want the sum:

= HOME::Table 1::B5+OFFICE::Table 1::B5+WAREHOUSE::Table 1::B5+COTTAGE::Table 1::B5

Reply