Or, to put it another way, FILTER removes rows that are zero.
This means that the two tests are mutually exclusive both tests can’t return TRUE at the same time.
In that case, the final array may contain numbers larger than 1 (i.e.
TRUE + TRUE = 2).This makes a difference in some formulas.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.