r中汇率市场_如何在Microsoft Word中汇总行和列-CSDN博客

r中汇率市场

If you need to total values in a Word table, you can do so without breaking out the calculator or entering the data into Excel and then copying it back. Word can do simple calculations such as summing, multiplying, and averaging.

如果您需要在Word表中总计值，则无需拆开计算器或将数据输入Excel，然后再复制回去即可。 Word可以进行简单的计算，例如求和，相乘和平均。

Let’s say you have a table something like the following. You have the units sold and the per unit cost, and you want to multiply those to get a total.

假设您有一张类似以下的表格。您拥有已售出的单位和每单位成本，并且想要将其相乘以获得总计。

Start by placing your insertion point into the blank top cell in the “Total” column.

首先将插入点放在“总计”列的顶部空白单元格中。

Next, switch to the new “Layout” tab that appears toward the right end of the Ribbon (there’s a separate Layout tab just for tables) and then click the “Formula” button.

接下来，切换到功能区右端出现的新“布局”选项卡(有一个单独的“布局”选项卡仅用于表格)，然后单击“公式”按钮。

click the formula button on the layout tab

In this example, we are going to multiply the value in the “Units” column by the value in the “Unit Cost” column. To do this, type the following into the “Formula” field to multiply the values in the two cells to the left of the current cell:

在此示例中，我们将“单位”列中的值乘以“单位成本”列中的值。为此，请在“公式”字段中键入以下内容，以将当前单元格左侧的两个单元格中的值相乘：

=PRODUCT(LEFT)

Select an option from the Number format drop-down list to specify the format for the result of the formula.

从数字格式下拉列表中选择一个选项，以指定公式结果的格式。

Click “OK” to accept the settings and insert the formula into the cell.

单击“确定”接受设置并将公式插入到单元格中。

The result of the formula displays in the cell.

公式的结果显示在单元格中。

Unfortunately, Word doesn’t let you select a bunch of cells at once and create a formula for all of them in one step, so you’ll have to perform these same steps in each of the other cells in the “Total” column.

不幸的是，Word不允许您一次选择一堆单元格并一步创建一个所有单元格的公式，因此您必须在“总计”列中的每个其他单元格中执行相同的步骤。

When you’re done, you’ll have a fully formed table.

完成后，您将拥有一个完整的表格。

This technique works pretty much the same way for columns as it does for rows. Say, for example, that we wanted to add all the values in the “Total” column to figure out our total overall sales.

此技术对列的作用与对行的作用几乎相同。举例来说，假设我们想将“总计”列中的所有值相加，以得出我们的整体销售总额。

Place your insertion point in an empty cell at the bottom of the “Total” column (insert an extra row if you need to). Head to the “Layout” tab and click the “Formula” button again.

将您的插入点放在“总计”列底部的空白单元格中(如果需要，请另外插入一行)。转到“布局”标签，然后再次单击“公式”按钮。

This time, we’ll use the following formula:

这次，我们将使用以下公式：

=SUM(ABOVE)

The “ABOVE” parameter tells Word to add all the values above the current cell.

“ ABOVE”参数告诉Word将所有值添加到当前单元格上方。

Select an appropriate Number format and click “OK.”

选择适当的数字格式，然后单击“确定”。

The total of all the values in the “Total” column displays in the cell.

单元格中显示“总计”列中所有值的总和。

Note: If you add new rows or columns of values to a table in Word, the formulas you’ve got in place will not automatically update. To update a formula, right-click on the formula and choose “Update Field” from the popup menu.

注意：如果在Word中向表中添加值的新行或新列，则现有公式将不会自动更新。要更新公式，请右键单击该公式，然后从弹出菜单中选择“更新字段”。

When it comes to managing data in tables, Word offers nowhere near the power of Excel. It’s fine for small tables like this where you don’t expect values to change much and you don’t need to view your data in different ways. If you need more functionality, you’re much better off inserting an actual Excel spreadsheet into your Word document.

在管理表中的数据时，Word无法提供Excel的强大功能。对于像这样的小表，这是很好的，您不希望值发生太大变化，并且不需要以不同的方式查看数据。如果需要更多功能，最好在Word文档中插入实际的Excel电子表格。