Google 表格单元格信息 [英] Google Sheets cell info

问题描述

我正在制作用于会计目的的分类帐.我把它设置成一个支票簿注册表.它有 4 列:日期、描述、金额和余额.在最后一列(余额)中设置的公式被设置为将金额"中的数字相加.列到最后一行条目中的余额.公式被复制到页面的最后一列.我想做的是，如果该行上有条目，则该列中只有一个数字.这是我的问题:有没有办法隐藏最后一列中的数字，直到该行上有条目?我希望额外的 15 美元条目保持隐藏状态，直到金额"中有一个值.该特定行上的列.

I am doing a ledger for accounting purposes. I have it set up like a checkbook registry. It has 4 columns: Date, Description, Amount and Balance. The formula set up in the last column (Balance) is set up to add the number in the "Amount" column to the balance in the last line entry. The formula is copied down the page in the last column. What I would like to do, is only have a number in that column if there is an entry on that line. Here is my question: Is there a way to hide the number in the last column until there is an entry on that line? What I would like is for the additional entries of $15 to remain hidden until there is a value in the "Amount" column on that particular row.

我希望这一切都有意义！我不知所措！任何帮助表示赞赏:)

I hope this all makes sense! I'm at a loss! Any help is appreciated :)

推荐答案

简单而缓慢:

=INDEX(IF(C2:C="",, MMULT(
 TRANSPOSE((ROW(C2:C)<=
 TRANSPOSE( ROW(C2:C)))*C2:C), ROW(C2:C)^0)))

=INDEX(IF(C2:C="",,SUMIF(ROW(C2:C), "<="&ROW(C2:C), C2:C)))

=ARRAYFORMULA(MMULT(
 TRANSPOSE((ROW(INDIRECT("C2:C"&MAX(ROW(C:C)*(C:C<>""))))<=
 TRANSPOSE( ROW(INDIRECT("C2:C"&MAX(ROW(C:C)*(C:C<>""))))))*
                INDIRECT("C2:C"&MAX(ROW(C:C)*(C:C<>"")))),
          QUERY(INDIRECT("C2:C"&MAX(ROW(C:C)*(C:C<>""))),  
          "select 1 label 1''")))

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