Google电子表格总计或某些列的行 [英] Google Spreadsheets sum or rows of certain columns

问题描述

我是Google Spreadsheets语法的新手，如果听起来太琐碎，请原谅我。 ：）

我想将Google Spreadsheets表格中某些列的行值汇总到一个新列中。

我正在寻找正确的命令来做到这一点。

到目前为止，我偶然发现是sum函数= SUM（A1：F1）---将列A的行值加总到第一行的F列。但是，我只想总结某些列---例如只有B和D的行值。

最小工作示例

  |列A | B列|列C | D列|总和B + D | 
 | ---------- | ---------- | ---------- | ---------- |  - ---------- | 
第1行| a1 | b1 | c1 | d1 | b1 + d1 | 
第2行| a2 | b2 | c2 | d2 | b2 + d2 | 
第3行| a3 | b3 | c3 | d3 | b3 + d3 | 
  

我想用电子表格公式构造最后一列（和B + D）。

解决方案

第1步：双击要插入公式的单元格。

<第3步：如何将公式应用于整列？

• 方法1：单击并拖动，直到需要应用公式的位置。 / li>
  

• 方法2：双击单元格的右下角。如上所述，该公式将应用于所有占用的单元格。

编辑（对于Google电子表格）。方法2：双击单元格右下角的并，将其向下拖动到您想要应用的行;当所有行都被选中时释放以应用。该公式将应用于所有占用的单元格。

I'm new to Google Spreadsheets syntax, so forgive me if this sounds too trivial. :)

I want to sum up the row values of certain columns in my Google Spreadsheets sheet into a new column.

I'm looking for the right command to do this.

What I've stumbled upon till now is the sum function =SUM(A1:F1) --- to sum up the row values of column A up to column F for the first row. However, I only want to sum up certain columns --- i.e. only the row values of B and D for instance.

Minimal Working Example

     | Column A | Column B | Column C | Column D | Sum B + D |
     |----------|----------|----------|----------|-----------|
Row 1| a1       | b1       | c1       | d1       | b1 + d1   |
Row 2| a2       | b2       | c2       | d2       | b2 + d2   |
Row 3| a3       | b3       | c3       | d3       | b3 + d3   |

I want to construct the last column (Sum B + D) with a spreadsheet formula.

解决方案

Step 1: Double click on the cell where you want to insert the formula.

Step 2: Bring the mouse pointer to the highlighted area as shown in below image till you see a '+' sign.

Step 3: how to apply formula to entire column?

• Method 1: Click and drag till the where you need the formula to be applied.

• Method 2: Double click on bottom right hand corner of the cell. The formula will be applied to all occupied cells as you mentioned.

• Edit (for Google Spreadsheets). Method 2: Double click on bottom right hand corner of the cell AND drag it down up to the row to which you want to have it applied; when all rows are selected release to apply. The formula will be applied to all occupied cells as you mentioned.

这篇关于Google电子表格总计或某些列的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！