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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
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