CODEWITHSUNDEEP
excelsum
sanapala praveen
sanapala praveen

Reputation: 11

How to calculate/sum numbers in a single cell in excel?

Example:

In a single cell I want to calculate 10+20+30 and the answer should appear into the next adjacent cell.

Hope this helps in understanding the question.

Thanks In Advance.

Upvotes: 1

Views: 6961

Answers (1)

Ceredig
Ceredig

Reputation: 131

The following thread will answer your question.

How to turn a string formula into a "real" formula

Check article pointed to in the answer by @iDevlop (not the accepted answer). EVALUATE function in a 'name' is probably the easiest way to go.

Edit:

Rough directions:

  • Create a new name (Eg. myResult) and associate its value to evaluating the cell your expression is to by typed in (Eg: assuming your text expression is in cell A1 of stylesheet Sheet1: =Evaluate(Sheet1!$A$1))
  • In the next cell (where you wish the result to be displayed), add a formula that simply evaluates the name you created (Eg: =myResult).

How you create a new name depends en the Excel version. On Excel 2010/2013: Formulas -> Name Manager -> Define Name. For older versions, refer to thread mentioned above.

Upvotes: 1

Related Questions