Forum Discussion

Simon_Cheung's avatar
Simon_Cheung
Copper Contributor
Dec 07, 2023

Need help with excel formula

Please help

 

How to add a total sum from Sheet A C796 and D796 to Sheet B C20. Thank you.

excel
  • SnowMan55's avatar
    SnowMan55
    Bronze Contributor
    Dec 07, 2023

    Simon_Cheung 

    If you intend to add the values in the two Sheet A cells and put the result into the Sheet B cell, replacing what is in C20, then you can place any of the following three formulas into cell C20.  (I assume that "Sheet A" is the actual worksheet name.)

    ='Sheet A'!C796 + 'Sheet A'!D796
=SUM('Sheet A'!C796, 'Sheet A'!D796)
=SUM('Sheet A'!C796:D796)

    The last formula can use a range because the two cells are adjacent.  For the middle formula, you may need to replace the comma with a semicolon; it depends on your regional settings.


    But if you intend to add the values in the two Sheet A cells plus the value currently in C20, and put the result back into C20 ... you'll need to be more specific. You could hard-code the value in C20 as part of the formula, or use VBA code (depends on what behavior you wanted, but this option is not recommended).

Resources