Sum up a named range

Hi Julian,

In Numbers Preferences, General, you could check the "Use Header names as labels" check box, which substitutes the column and row names for the column letter and row number. "Named Ranges," as defined in MS Excel, are not a sppored feature in Numbers.

A more Numbersy approach (is that really a word!?) is to size your tables to fit the need.

Making your table 56 rows tall (plus footer rows, if needed, and defining Row 1 as a Header row, would allow changing that C2:C56 reference to C or with the box mentioned above checked, to "Data" (assuming the column label in C1 is "Data".

Regards,

Barry

A table is a named range. As already proposed, size the table as needed then sum all the columns of the table

The first two menus on the menu bar are always the System menu (Apple menu) and the Application menu for the appl;ication you are currently using.

When the active application is Numbers, Numbers preferences are here:

(This is the preferences pane as it appears in Numbers 3.6.2. The appearance may be different in your version.)

Note the key symbols command and comma to the right of Preferences. These are the keystroke combination that will take you directly to Numbers preferences (when Numbers is the active application).

Regards,

Barry

HI Julian,

Thought that might be the case when I noticed this was a 'first post' in the community, and checked the hardware and OS specs below your question. I took a look on the iPad after that, and did not find that prefs setting (or a lot of others). I suspect it may be like several other features—if they're set up on a document originally created on a Mac, iOS will honour them, but there is no means of activating the feature while you are on the iOS device.

You may get a more knowledgable answer form someone in the iWork for iOS community, so 'll request this discussion be transferred there.

Regards,

Barry

PS: Don't be surprised at winding up in the Numbers for Mac community. Apple has never marketed the iOS versions as an iWork bundle, but that detail bypassed whoever decided to place Pages, Numbers and Keynote for iOS into a single community and name that community "iWork for iOS.