对Google表格中的表格中的所有单元格求和 [英] Sum the same cell across the sheets in Google Sheets

问题描述

我每个月的每一天都有一张床单.在每个月末，我需要在所有选项卡中汇总相同的单元格.以下作品:

I have a sheet for every day in the month. At the end of every month, I need to sum the same cell across all tabs. The following works:

=SUM(March31!L2,March30!L2,March29!L2,March28!L2,March26!L2,March25!L2,March24!L2)

但是，在月底，公式将是巨大的.尝试了以下内容:

However, at the end of the month, the formula will be tremendous. Tried the following:

=SUM(March31:March1!L2)

不起作用.甚至有可能吗?

Doesn't work. Is it even possible?

推荐答案

SUM(March31:March1!L2)

那是行不通的，但是您可以使用一种生成器:

that won't work, but you can use kind of a generator:

={" "; ARRAYFORMULA("=SUM("&TEXTJOIN(", ", 1, TEXT(ROW(INDIRECT(
 DATEVALUE("2020/01/01")&":"&DATEVALUE("2020/12/31"))), "mmmmd!L2"))&")")}

这将为您提供所需的完整公式，因此您需要做的就是复制粘贴以下单元格

which will give you the full formula you need so all you need to do is copy-paste the cell bellow

这篇关于对Google表格中的表格中的所有单元格求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！