If Array (CSE) argument encounters blank cells, formula ignores them, but considers cells with zeros.
Blanks cells produces different results then, if zeros are in there.
You keep blanks or if you intend to have more accurate result, then replaces blanks with zeroes.
An array (CSE) formula in Cell
Array (CSE) formula in Cell
A146 tests blanks has different result, since consider blanks as zero:
Finish formula with Ctrl+Shift+Enter.
Blank cell replaced with Zeros.
- Now you can find formula in Cell
A142 & in Cell
A146 has similar outcome.
Adjust cell references in the formula as needed.