Been bashing my head over this for hours.
Here is the data and desired result:
A1 has the string
I need B1 to show the
SUM of A1
I've managed thus far by just copying and pasting the text into B1 and placing a
= in front of it i.e. (
=204+204+... etc.) But I know there has got to be an easier way.
Here is how to do it.
Open the Name Manager. Control-F3 from the worksheet, and then click the New button.
For the Name field in the dialog, enter
EVALA. I just picked this name; it stands for "Evaluate A". But you can pick whatever name you like.
Refers to field, enter this
Click OK and then Close.
In B1 enter this formula:
You can now use this formula on any row in the worksheet and it will evaluate whatever is in the column A cell of the row where you enter the formula.