CountIf 指令

本頁為官方文件，一般使用者無法修改，若有任何誤謬，請與官方聯絡。如欲編輯，請至本頁的開放版。

CountIf[ <Condition>, <List> ]

目前本頁中文說明尚未翻譯完成，請先連至英文說明。如果您有權限，請幫忙翻譯本頁的官方手冊。

CountIf[Condition, List]

Counts the number of elements in the list satisfying the condition.

範例：

• CountIf[x < 3, {1, 2, 3, 4, 5}] gives you the number 2.
• CountIf[x < 3, A1:A10], where A1:A10 is a range of cells in the spreadsheet, counts all cells whose values are less than 3.

備註： For list of numbers arbitrary condition may be used. For list of other objects one can use only conditions of the form x==constant or x!=constant.