Aug 29 2020 09:55 AM
Aug 29 2020 11:05 AM
You wrote: In one cell, I have something like this: 1*5+30
I want some other cell to display sum of the content in that cell. =SUM(A2) does not work. How to do that?
So may I ask you what the answer should be? What are you expecting as the "sum of the content in that cell"?
In any event, why don't you have cell A2, which presumably is where you figures appear, written as
If you did, you'd be getting the result right there (35). As it is, by entering it without the preceding equals sign, you're de facto treating it as text.
So let's see if we can get a little background here. WHY are you entering that first string of characters, some of which happen to be numbers, in that fashion? There are ways to handle this, but before we get to that, there may also be a much better way to get to the desired result.