I have just downloaded Numbers and opened a spreadsheet. I can't get the SUM function to work on currency figures. It just can't seem to read them. Anyone else had this problem ?

can you post a screenshot of the table in question?

To post a screenshot make the area of your sheet visible on the screen, then type the key combination:
<command> + <shift> + 3 (<command> is the key with the  on it)

then click, and hold, at the top left corner, drag to the bottom-right corner then release the mouse button.

return to this forum, click the camera icon in the toolbar, navigate to the desktop, and select the fil titled "Screenshot..."

One way to enter a sum is to select the cells you want to sum in a table, then drag the "SUM" from the quick calculation area t the bottom left of the window:

Dirk,

When values don't act like values, maybe they aren't. There may be extra spaces or other content that you can't see that makes them not values. The most likely cause of that problem is Copying and Pasting from another source.

Jerry

Enter the values as numbers. Incude the decimal separator (if necessary), but do not enter the thousands separators or the currency symbol, and do not insert spaces into the number.

Use the Cell Inspector to format the cells as Currency, check the Thousands Separator if you wish them to be inserted.

Regards,

Barry