COUNTIF function. 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. In its simplest form, COUNTIF says:

COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required.

如何在 Excel 中使用 SUMPRODUCT 函数（Excel 的数学函数和三角函数之一），使用乘法、加法、减法和/或除法返回相应范围或数组的乘积之和。.

ROUND 函数将数字四舍五入到指定的位数。. 例如，如果单元格 A1 包含 23.7825，而且您想要将此数值舍入到两个小数位数，可以使用以下公式：. =ROUND (A1, 2) 此函数的结果为 23.78。.