Forum Discussion
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.
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).