Aug 29 2020 09:55 AM
Hello.
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?
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
=1*5+30
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.
Aug 29 2020 12:38 PM
Not sure what exactly do you mean, as variant you may use named formula as
the only the file shall be saved as macro-enabled.