-
All replies
-
Helpful answers
-
Sep 27, 2016 6:15 PM in response to Dominic202by Wayne Contello,without specific details it is hard to guess.
Often the cell is not the same as the other in some way. Perhaps it is formatted as text, or there is a funny character in the cell. Try copying the data to a new table in a new document to double check the results.
If you can post the data then we can try too.
-
-
Sep 27, 2016 8:08 PM in response to Dominic202by Barry,Like Wayne, I'm mystified by the issue and by the description.
Can you provide a screenshot that includes the result cell showing the result, the formula as it appears in the formula editor, and the column of numbers that is to be summed?
Procedure:
Double click the result cell to open the formula editor.
Drag the editor away from the result cell to show the result as calculated.
Take a screen shot that includes the three elements listed above.
- Place mouse pointer at top left of area to be included.
- Press shift-command-4. The pointer will change to a crosshair.
- Press and hold the mouse button and drg the pointer to the lower right corner of the area to be included.
- Release the mouse button.
Post the screen shot here:
- Click the cameral icon.
- Click Choose file.
- In the dialogue window, go to your Desktop, and choose the file (Screen shot... and the date and time taken)
- Click Choose.
- Click Insert Image.
The screenshot image will be inserted in your post.
Regards,
Barry

