Crazy that I can't figure out how to simply add a column of numbers in a table created in Pages. It was very simple in Word. I create a formula, e.g. =sum(b1:b20), and no total appears.
iMac 21.5", macOS 10.13
Double-check that the cell contents between B1:B20 are all numbers, because there is a requirement of the sum function that all cell entries be of the same type. Sum works for me in Pages v8.2.1.
Thanks very much to both of you! When I created a new column and typed in the numbers I was able to get a total using the formula. It's a mystery why the original column of numbers didn't work, because the numbers are identical. Something must have been corrupted somewhere...
After posting the question I removed several rows and still could not get a total. Finally, I added a new column, typed in the numbers and only then did I get a total.
Possibly a format setting for the data in some of the cells.
Possibly the addition of some non-visible characters in those cells causing Numbers to see the contents as text.
Was the original data typed directly into the column, or did it get there via other means?
Regards,
Barry
There isn't one line of MS Word code in Pages, so do not expect it to behave identically.
A selected table in Pages has two circle icons with a '=' for row, and '||' for column increment/decrement. If you right-click on an alphabet column, you will have the option to add a column before, or after the current selected column.
Single-click a cell before entering your equation.
See the Add Tables section of the online Pages User Guide for Mac.
Thanks for your reply! My table is already created in Pages, and I don't need to add columns or rows. I have a column of numbers that I want to total. I click on the cell where the total should appear. I have the option of inserting a formula, which I thought was =sum(b1:b20). Meaning Column B, rows 1 through 20. The number that appears is "3", which is not the correct answer at all.
Via other means. I opened an original Word document containing the table in Pages and saved it in Pages. Then I removed several rows and attempted to total the column of remaining numbers.
As an aside, I am moving away from Word and Excel in favor of Pages and Numbers.
THX
"Via other means. I opened an original Word document containing the table in Pages and saved it in Pages. Then I removed several rows and attempted to total the column of remaining numbers."
Was this before or after posting your question? If after, did it clear up the problems?
Regards,
Barry
Works here, with Pages 5.6.2 in OS X 11.6
Table contains 20 rows, and crosses a page boundary. Cells in column B exch contain their row number.
Formula shown is in cell A2.
Cell A5 contains the similar formula: SUM(B1:B20)
Which produces the same result.
Is it possible that some of the 'numbers' in your column are actually "Text" values.not "numbers"?
Regards,
Barry
Cannot add column of numbers in Pages table
