Pages

Hi SuFuGirl,

Here's a step by step description of the process:

We want to SUM the two values in cells B2 and C2, and display the result in cell D2

1. Click once on cell D2 to select it.

With the cell selected, press = to open the formula editor.

type   sum 

  SUM will appear twice, once in the editor, the other in the bar below the editor.

Click either copy of SUM.

Click value, then click cell B2. type a comma.

The first 'value' will change to the cell address B2.

When you type the comma, a new 'value' will appear.

Click value, then click cell C2.

Your formula in now complete.

Click the green checkmark button to confirm the formula and close the editor.

The formula's result will be seen in the cell (D2) containing the formula.

Regards,

Barry

PS: This was done with a table in Numbers, but the process is the same in Pages.

B.

SuFuGirl wrote:

, I have to click below to get the keyboard to pop up since I do not have a separate keyboard. When I push = it just types it in the cell and nothing comes up for formula. Sorry I just can’t figure this out. I do appreciate your explanation but I figured it out without a separate keyboard last time and now it’s not cooperating!

If you are working on an iPad, I don't think Pages supports formulas in tables. Here is how to do it in Numbers:

https://support.apple.com/guide/numbers-ipad/insert-formulas-and-functions-tan727173a8/ipados

Here is a table example with product information, cost, qty, and line totals. And a final Line Total summary.

I selected each column and set the cell data format accordingly.

There are two formulas in this table. There is a Line Total formula associated with cell E2 thru E4, and a Line Total Summary located in cell E5.

In E2, I clicked once to select the cell, and then entered an = to open the formula input. I then entered C2*D2 and pressed enter to set that equation. I then replicated this formula downward by passing the pointer over the bottom of the E2 cell to reveal a gold dot, and then clicked and dragged downward to include cell E4. This automatically produced Line Totals for the line items.

In cell E5, I entered the = and the formula became SUM(E2:E4) to provide a grand total of the line items.

Does this clarify?

'adding the total for two cells' requires a formula in the cell that is to display the result.

If your document has 'stopped' doing that, the most probable cause is that the formula has been removed from the cell, either intentionally or accidentally.

Regards,

Barry

In my Pages '09, if the cell is formatted as Text I won't get the formula editor, just the equal sign. Maybe this is what is happening with you. If so, format the cell as Number or something else that can bring up the formula editor.

You don't get the formula editor when you type = in the cell?

https://support.apple.com/guide/pages/calculate-values-using-data-in-table-cells-tana41710df7/mac

You do not enter the cell, you click once to select it, and then type the '=' sign, which will never appear in the cell.

Are you working on an iPad? If so, your are in the wrong forum, it is for Mac, and the answers you get won’t fit.