救命!!!(有關excel countif)(20點)

2014-03-16 2:47 am
功課說要計及格人數,

這樣說行不行:

countif(c4:c38,>=50)

回答 (2)

2014-03-16 3:29 am
✔ 最佳答案
唔得,因為你冇係(>=50)加"
你可以改成
=COUNTIF(C4:C38,">=50)

2014-03-15 19:30:37 補充:
sorry 我打錯野
=COUNTIF(C4:C38,">=50")
2015-05-03 1:31 am
COUNTIF 示範: https://www.youtube.com/watch?v=yHIeo80uH_I
希望幫到你


收錄日期: 2021-04-13 20:19:10
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140315000051KK00143

檢視 Wayback Machine 備份