该列的总和值。循环依赖 [英] Sum values of the column. Circular dependency
问题描述
我不知道如何用语言说,但我需要我在这张电子表格
在附件的电子表格中有两张纸:现在是怎么回事和应该怎么回事。
我在其他工作表中使用此公式,但现在它无法正常工作:
<$ c如果(E:E + F:F(F))= f(F + G:G)-B:B)))
请删除第一个尾部的FALSE文字列在单元格区域之后。
在D1中,我需要D2:D的SUM。但是有一个错误循环依赖。请尝试。
:
= arrayformula(if(row(A:A)= 1; sum(if(isnumber(B:B); E:E + F:F + G:GB:B;));如果(LEN(A:A);如果(ISNUMBER(B:B); E:E + F:F + G:GB:B;))) )
I don't know how to say in language, but I need what I realize in this spreadsheet
In attached spreadsheet there are two sheets: "How it is now" and "How it should be".
I use this formula in other sheets, but now it doesn't work correctly:
=ArrayFormula(IF(ROW(A:A)=1; SUM(INDIRECT("D2:"&"D")); IF(LEN(A:A); (E:E+F:F+G:G)-B:B)))
Please remove the trailing FALSE text in the first column after the cell range.
In D1 I need a SUM of D2:D. But there is an error "Circular dependency". Try please.
For everyone interested, the answer from myself:
=arrayformula(if(row(A:A)=1;sum(if(isnumber(B:B);E:E+F:F+G:G-B:B;));if(len(A:A);if(isnumber(B:B);E:E+F:F+G:G-B:B;);)))
这篇关于该列的总和值。循环依赖的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!