在Google电子表格中超出工作表的总和范围 [英] Sum range over sheets in google spreadsheets

问题描述

我有床单：S，A，B，C，D。在SI想要做的事情中对于某个单元格C4）：

  = SUM（A：D！C4）
  

在A，B，C和D中总结C4。它完全可以在Google电子表格中使用吗？

解决方案

您只需要提及表单名称。尽管如此，你必须单独提及每个表单名称。像这样的东西可以工作

= SUM（A！C4，B！C4，C！C4，D！C4）

Is it possible to range over sheets in one spreadsheet ?

Ive got sheets: S, A, B, C, D. In S I would like to do (for some cell C4):

 =SUM(A:D!C4) 

To sum C4 in A, B, C, and D. It is doable in google spreadsheet at all ?

解决方案

You just need to mention the sheet names as well. Though, you'll have to mention each sheet name seperately. Something like this would work

=SUM(A!C4, B!C4, C!C4, D!C4)

这篇关于在Google电子表格中超出工作表的总和范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！