UPDATE::
The Example in the Answer below works, But it may be from a result of some sort of BUG in Pages.
I did not save the test document when I did this until now.
It seems when you reopen the Document. It saves the result in the total cell of Table A, as text. i.e removes the formula.
So the REAL answer is NO. you cannot do this in Pages.
You CAN do what you want in Numbers
Original Answer
In the cell of Table (A) the table you want the sum; type a equals symbol. =
You will now get a the formula box.
(cell in table A)
Type SUM(headerTitle) in front of the = with no spaces.
(cell in table A)
The headerTitle being a Header Title from Table (B)'s Header Row or Header Column.
In this example I use Table B's Header Row title 'headRowTitle2'
(table B)
(The Row in table B will highlight to show the cells Table A will be using)
Click the green tick button. It should now display the total you want.
(table A)
Another way to do this without clicking in each cell would be to use the =HYPERLINK()
function.
Here are some steps:
- Add a second column (Let's call it B)
- In the adjacent cell, add a formula like this:
=HYPERLINK(A1)
- Drag the formula down
Provided that the original URL's are valid, this will convert them.
You can even add your own text in place of the URL. (see screenshot)
So, given column A has a long list of URL's starting in cell A1
, then in B1
enter:
=HYPERLINK(A1,"Clickable Link")
One could even parse the original URL to get just the human readable part using MIDDLE()
or similar.
Hope this helps!!
Sample Numbers Formula for Hyperlink
Best Answer
I have had the best luck keeping the data in Numbers and only pasting tables and graphs into Pages. But that is because I like the added tools in Numbers and not that I've had any issues pasting back or forth.
I've done a few tests and can't replicate your issue on '09 versions of both iWork programs. Have you experimented pasting the data from pages to numbers as values (or paste and match style)? It is a long shot, but the two things that come to mind is pasting into a new spreadsheet (in case the one you are using has some sort of issue) or pasting data that is somehow formatted to cause an obscure problem.