Forum Discussion

Paul Anderson's avatar
Paul Anderson
Copper Contributor
Sep 12, 2018
Solved

Formulas

I am trying to write a formula for taking data from a  cell in sheet 1 adding that to data from a cell in sheet 2 and putting the total into a cell in sheet 3. how would I write such  formula in the active cell on the third sheet 

Paul

Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Sep 12, 2018

    Hi Paul,

     

    Let's say that the value in sheet 1 is in cell A1, and the value in sheet 2 is in cell A1 as well.

    So please start in any cell in sheet 3 and fill it with this formula:

    =SUM(Sheet1!A1, Sheet2!A1)

    The trick is to type the sheet name before the cell reference.

     

    But if the sheet name contains a space, you have to wrap it with the single quotes as follows:

    =SUM('Sheet 1'!A1, 'Sheet 2'!A1)

    And these quotes will be added automatically if you have a formula and later changed the sheet name that the formula refers to.

     

    Hope that helps

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Sep 12, 2018

    Hi Paul,

     

    Let's say that the value in sheet 1 is in cell A1, and the value in sheet 2 is in cell A1 as well.

    So please start in any cell in sheet 3 and fill it with this formula:

    =SUM(Sheet1!A1, Sheet2!A1)

    The trick is to type the sheet name before the cell reference.

     

    But if the sheet name contains a space, you have to wrap it with the single quotes as follows:

    =SUM('Sheet 1'!A1, 'Sheet 2'!A1)

    And these quotes will be added automatically if you have a formula and later changed the sheet name that the formula refers to.

     

    Hope that helps

Resources