Forum Discussion

Paul Anderson's avatar
Paul Anderson
Copper Contributor
Sep 11, 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 ...
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Sep 11, 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

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 11, 2018

I hope the attached is what you need..

just change the sheet name or cell to suit your requirements.

thanks

 

Paul Anderson's avatar
Paul Anderson
Copper Contributor
Sep 11, 2018
Thanks but somebody else has helped me