Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

Learn how to use the COUNTIF function to count numbers or dates that meet a single condition, such as equal to, greater than, or less than. See examples, syntax, and tips for using COUNTIF with dates and other criteria.

Learn how to use COUNTIF, COUNTIFS, COUNT, IF, SUM, IF, and PivotTable functions to count the number of times a value appears in a range of cells. See examples, formulas, and tips for different scenarios and criteria.

COUNTIF 是一个 统计函数，用于统计满足某个条件的单元格的数量；例如，统计特定城市在客户列表中出现的次数。 COUNTIF 的最简形式为： =COUNTIF (要检查哪些区域? 要查找哪些内容?) 例如： =COUNTIF (A2:A5,"London") =COUNTIF (A2:A5,A4)

วิธีใช้ฟังก์ชัน COUNTIF ใน Excel เพื่อนับจํานวนเซลล์ที่ตรงกับค่าที่คุณตั้งค่าไว้

Cara menggunakan fungsi COUNTIF di Excel untuk menghitung jumlah sel yang memenuhi nilai yang Anda tetapkan.

If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

COUNTIF 是 統計函數 之一，用來計算符合準則的儲存格數目，例如計算特定縣市出現在客戶清單的次數。 以其最簡單的形式而言，COUNTIF 表示： =COUNTIF (要查看的位置？ 要尋找的項目？ ) 例如： =COUNTIF (A2:A5,"倫敦") =COUNTIF (A2:A5,A4)

COUNTIF: To count cells that meets a specified criteria. Tip: To enter more than one criterion, use the COUNTIFS function instead. Select the range of cells that you want, and then press RETURN.