这是数据和期望的结果:
A1有字符串 204 + 204 + 204 + 204 + 204 + 204 + 59
我需要B1显示A1的 SUM
通过将文本复制并粘贴到B1中,我已经管理到目前为止,前面的 = ie( = 204 + 204 + ... 等)但是我知道有成为一个更简单的方法。
解决方案这是如何做到的。
1打开名称管理器。 Control-F3,然后点击新建按钮。
2对话框,输入 EVALA 。我刚刚选了这个名字它代表评估A。但是你可以选择你喜欢的任何名字。
3对于 字段,输入
=评估($ A1)4
单击确定,然后单击关闭。
5在B1中输入以下公式:
= EVALA就是这样。
您现在可以在工作表中的任何行上使用此公式,它将评估您输入公式的行中的单元格中的任何值。
Been bashing my head over this for hours.
Here is the data and desired result:
A1 has the string 204+204+204+204+204+204+59
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.
1Open the Name Manager. Control-F3 from the worksheet, and then click the New button.
2For 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.
3For the Refers to field, enter this
=EVALUATE($A1)4
Click OK and then Close.
5In B1 enter this formula:
=EVALAThat's it.
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.
更多推荐
Excel对相邻单元格的文本值求和
发布评论