Excel BD3至CZ3內有1，-1或空格 Q1)現於DA3計算出現第一次1是第幾個數字(不計空格)例如：空,-1,空,-1,1,1,-1,1,空,-1,1,1,空...答案是3。(如全是空格，便是空格) Q2)現於DB3計算如整行無1，有幾多-1出現。(如全是空格，便是空格)?
回答 (2)
2017-05-09 1:11 pm
✔ 最佳答案
.DA3:
=IF(COUNTIF(BD3:CZ3,1),COUNT(OFFSET(BD3,,,,MATCH(1,BD3:CZ3,))),"")
DB3:
=IF(COUNTIF(BD3:CZ3,1),"",COUNTIF(BD3:CZ3,-1))
DC3:
=IF(LOOKUP(2,BD3:CZ3)=-1,COUNTIF(BD3:CZ3,-1)-1,"")
2017-05-09 12:32 pm
DA3=IF(ISNA(MATCH(1,$BD$1:$CZ$1,)),"",MATCH(1,$BD$1:$CZ$1,)-COUNTBLANK(INDIRECT("BD1:"&ADDRESS(1,MATCH(1,1:1,)))))
DB3=IF(COUNTIF(BD1:CZ1,1)=0,COUNTIF(BD1:CZ1,-1),"")
DB3=IF(COUNTIF(BD1:CZ1,1)=0,COUNTIF(BD1:CZ1,-1),"")
收錄日期: 2021-04-28 17:31:47
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170509025005AAY7rx0