How do I add values across different Numbers files

Question

Level 1

4 points

How do I add values across different Numbers files

I am a PE teacher and I have two documents which both have data in them. I would like to know how to add data from a range of cells in one document to a cell in another document. I know I can do this in Excel but have recently purchased a Macbook and need to know the equivalent in Numbers.

I have recorded points students have scored for their sports houses in a table on a sheet in a "Swimming" Numbers document. I have another Numbers document "Cross Country" previously setup to record house points for the cross country.

The "Cross Country" document also has a Running House Points Total on one sheet.

I would like to add more points from the "Swimming" document to the Running Total on the "Cross Country" document.

Can someone help me write the formula?

I know in excel all I had to do is type SUM then in the range input click on the Workbook:Worksheet:Cell Ranges then press enter. Simples. This doesn't work for me in Numbers. AARGH😕😠

MacBook Pro (13-inch Mid 2012), iOS 8.3

Posted on May 28, 2015 4:44 AM

Reply

Answer 1

May 28, 2015 4:54 AM in response to RangerJP

Numbers cannot refer to cells in another document. The only way you can solve your problem is to combine the several documents into a single document. I would suggest moving the sheets of one into the sheets of another by, one at a time, selecting the sheet to move, then use the contextual menu for that sheet to copy, then switch to the destination doc, and past the sheet using the contextual menu of any sheet

Reply

Answer 2

t quinn

Level 5

7,043 points

May 28, 2015 7:18 AM in response to RangerJP

Hi RangerJP,

I think in the long run you will like Wayne's solution above. With specifics it is possible to create an applescript that would copy your column between sheets. It would have to be run each time you wanted to update.

quinn

Reply