Using Formulas That Span Multiple Worksheets

Contact Us or call 1-877-932-8228
Using Formulas That Span Multiple Worksheets

Using Formulas That Span Multiple Worksheets

To create a formula that spans multiple worksheets:

  1. If you haven't named cells, then:
    1. Select the sheet and cell into which you wish to type the formula.
    2. Type "=".
    3. Select the sheet that includes the data you will use in your formula.
    4. Select the cell that contains the data.
    5. Enter an operator (+, -, *, /).
    6. Either select another cell in that sheet or select another sheet and cell to complete the formula.
  2. If your formula contains named cells or ranges, simply:
    1. Select the sheet and cell into which you wish to type the formula.
    2. Type "=".
    3. Enter the formula using names.
Next