=if(A"","1","").如何实现该公式下拉时,"1"中的数字1也增加1或增加n?
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/26 04:07:46
![=if(A](/uploads/image/z/7221659-59-9.jpg?t=%3Dif%28A%22%22%2C%221%22%2C%22%22%29.%E5%A6%82%E4%BD%95%E5%AE%9E%E7%8E%B0%E8%AF%A5%E5%85%AC%E5%BC%8F%E4%B8%8B%E6%8B%89%E6%97%B6%2C%221%22%E4%B8%AD%E7%9A%84%E6%95%B0%E5%AD%971%E4%B9%9F%E5%A2%9E%E5%8A%A01%E6%88%96%E5%A2%9E%E5%8A%A0n%3F)
=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),"")
下拉复制