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

问题描述

出于会计目的，我正在做一个分类帐.我将其设置为支票簿注册表.它有4列:日期，说明，金额和余额.设置在最后一列(平衡)中设置的公式，以将数字添加到余额"中.列到最后一行条目中的余额.公式将复制到最后一列的页面中.我想做的是，如果该行上只有一个条目，则该列中只有一个数字.这是我的问题:有没有办法在最后一行中隐藏数字，直到该行上没有条目?我想要的是$ 15的其他条目保持隐藏，直到在"Amount"中有一个值为止.该特定行上的列.

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屋！