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 という事実に基づいています。個々の比較結果は行列として扱われ、行列乗算で使用されます。最後に個々の値が合計され、結果行列が計算されます。