using a formula across sheets in numbers

8,143

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:
8,143

Related videos on Youtube

Sam
Author by

Sam

Updated on September 18, 2022

Comments

  • Sam
    Sam almost 2 years

    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

    • soandos
      soandos over 12 years
      You want to total everything on the sheet? And you are using the spreadsheet program, or something else?
    • Sam
      Sam over 12 years
      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
    • Darius
      Darius over 12 years
      Will this LINK to tutorial help ?