The formula is based on the fact that the result of a comparison is 1, if the criterion is met and 0 if it is not. The individual comparison results will be treated as an array and used in matrix multiplication and at the end the individual values will be totalled to give the result matrix. The SUM() function can also be used in this way, for example, as COUNTIF() with several criteria.
此公式建立在比较结果的基础上，如果符合条件，则比较结果为 1，反之为 0。单个的比较结果将被视为数组，并用于计算矩阵乘积，最后将计算各个值的总和以得到结果矩阵。