What format should the cell be? This can not be added and only gives a exclamation mark - "the formula contains a syntax error. OS X and numbers v3.5.3

enter image description here

  • 1
    There are iOS versions of numbers and OS X versions of numbers. We can help if you edit these details into the post. The cell needs to contain an actual number and the steps to check and change that vary. Or you could use a function to convert strings to numbers, again that depends on the version. – bmike Sep 3 '15 at 16:24
  • Your screenshot shows adding two numbers, not cells. What do you really need? How to sum numbers or sum cells? – bjbk Sep 4 '15 at 11:52

The error at the bottom of your screenshot is from a previous entry. The Result bar does not update as you type—it updates when the cell contents changes. There's nothing wrong with that formula. Press Enter to enter the formula into the cell.


As for adding cells: whilst in formula edit mode, click the cell to insert its reference into the current cursor location, and use the standard syntax (something+something).


gagarside's answer is the correct answer.

To take this a step further, you could use the SUM function.

To sum values hard coded (like in your original post):

Hard code SUM fuction

To sum values in cells (more dynamic as one can change single values easily):

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .