How to add a column on multiple sheets in numbers 10.2

Ambiguous question. Please clarify.

Are you inserting a new column into one or more tables on several Sheets, or

are you calculating the sum of the values in a set of columns in one or more tables on several sheets?

Or are you summing a set of numbers in specific locations on one or more than one table?

A specific response requires more specific detail.

Where will the formula be placed? (Sheetname::Tableame::celladdress (columnandrow) )

Where are the cells to be summed? (Sheetname::Tableame::celladdress or cell range)

What is the location of each cell or group of cells to be summed?

Regards,

Barry

Or forget about union.ranges and use SUM(Sheet 1::Table 1::C2:C10,Sheet 2::Table 1::C2:C10,Sheet 3::Table 1::C2:C10)

How many "multiple sheets" are we talking about here?

In Numbers, the grid structure of cells is called a Table. One or more Tables may be on a Sheet. A Sheet is like a blank canvas that may have tables, text boxes, charts, shapes, etc. on it. There may be multiple sheets, each with its own tables, shapes, etc..

OK. I am assuming you mean you want to get the sum of all the values in a specific column of all tables in the document.

For the example, I'll assume there are four sheets, each with one table, and, with one exception, that you have not changed the names of the sheets or the tables from their initial default names (Sheet 1, Sheet 2, Sheet 3, Sheet 4, and Table 1 on Sheets 1, 2, and 3).

The data to be summed is in column C of each table.

The sum is to be calculated in cell B2 of the table on Sheet 4, which has been reduced in size and has been renamed "Summary".

Images of the three data tables:

Here is an image of the Summary table on Sheet 4. The formula in cell B2 is shown below the table.

B2: SUM(UNION.RANGES(FALSE,Sheet 1::Table 1::C2:C10,Sheet 2::Table 1::C2:C10,Sheet 3::Table 1::C2:C10))

Details on SUM and UNION.RANGES can be found in the Function Browser (which opens in the right sidebar when you click on a cell and type = )

FALSE in the formula sets the direction in which to compact the ranges if necessary. I left it at the default value, seen in the image above.

Regards,

Barry