=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/23 09:11:53
=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?=if(A"","1",

=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?
=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?

=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?
B1输入公式:
=IF(A1"",COUNTA(A$1:A1),"")
下拉复制