各位好,有一樣野想問下關於Excel既
如果我係Column A同B, A1-A10 同 B1-B10Pattern 如下:
A1:Yes
A4:Yes
A7:Yes
A8:Yes
B2:Yes
B8:Yes
有冇formula係可以係A11同B11輸入而得出A同B各有幾多個YES?
Excel Formula Setting
2014-06-30 6:02 pm
回答 (1)
2014-06-30 11:40 pm
✔ 最佳答案
喺A11輸入 =COUNTIF(A1:A10,"YES")喺B11輸入 =COUNTIF(B1:B10,"YES")
收錄日期: 2021-04-15 16:09:31
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140630000051KK00026