Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a numbers spreadsheet and am making a totals page to take the totals from each page, add them together in an overview sheet and was wondering if anyone knew how to create a formula to do t

share|improve this question
You want to total everything on the sheet? And you are using the spreadsheet program, or something else? – soandos Nov 29 '11 at 21:35
sorry yes numbers is the program I'm using and i have totals on the sheets and then i want an overall total of all of the sheets without having to manually input any changes – Sammy Nov 29 '11 at 21:39
Will this LINK to tutorial help ? – Darius Nov 29 '11 at 21:45

Try this on a simple file.

  1. Create two sheets. On the first, enter two numbers, and a formula to add them.

    note the formula

  2. On the second sheet, put a number somewhere, then, in another field, type "=", click on the number, click "+", point to the formula in the first sheet. Click.

    you can type in the formula, or use your mouse/pointing device

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.