Excel对相邻单元格的文本值求和 [英] Excel summing a text value of an adjacent cell
问题描述
这是数据和期望的结果:
A1有字符串 204 + 204 + 204 + 204 + 204 + 204 + 59
我需要B1显示A1的 SUM
通过将文本复制并粘贴到B1中,我已经管理到目前为止,前面的 =
ie( = 204 + 204 + ...
等)但是我知道有成为一个更简单的方法。
这是如何做到的。
1 < h1>
打开名称管理器。 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.
1
Open the Name Manager. Control-F3 from the worksheet, and then click the New button.
2
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.
3
For the Refers to
field, enter this
=EVALUATE($A1)
4
Click OK and then Close.
5
In B1 enter this formula:
=EVALA
That'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对相邻单元格的文本值求和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!