第 n 行到最后一行的总和 [英] Sum of row n through last row

问题描述

我想在我的电子表格顶部创建一个 TOTAL 行.在这一行中，每个单元格应该是 TOTAL 行下方列中的值的总和.

I want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be the SUM of the values in the column below the TOTAL row.

因此，例如，如果总行是第 1 行，则单元格 A1 应该是 A2 到 A 列中最后一行的总和.电子表格中的行数会随着时间的推移而增长，所以我不能只说SUM(A2:A500) 因为最终会有第 501、502 行等.

So for example, if the total row is Row 1, cell A1 should be the SUM of A2 through the last row in column A. The number of rows in the spreadsheet will grow over time, so I can't just say SUM(A2:A500) because eventually there will be row 501, 502, etc.

推荐答案

如果您想要只在 Google 电子表格中工作的东西(如标题所示)，您可以使用开放式范围:

If you want something that just works in Google Spreadsheets (as the title suggests), you can use open-ended ranges:

=SUM(A2:A)

在 Excel 中，您可以指定该版本的最大行数；例如，对于 2007 年和 2010 年:

In Excel, you can specify the maximum rows for that version; for example, for 2007 and 2010:

=SUM(A2:A1048576)

这也适用于 Google 电子表格，并且超出了 GSheets (400000)* 中当前的理论行数限制.

This will work in Google Spreadsheets as well, and is beyond the current theoretical row limit in GSheets (400000)*.

*新版表格的引用限制a> 现在实际上是 200 万个细胞.

*The quoted limit of the new version of Sheets is actually now 2 million cells.

这篇关于第 n 行到最后一行的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！