SUMIFS etc seem to be capable of some form of native error suppression.

Perhaps only a TIL to me, but seen in another post it appears that that SUMIFS-etc suite can ignore errors, to some degree at least.

TL;DR: SUMIF(rng,">=0") sums all positive values in range, even if errors are present in range. SUMIF(rng,">-9e307") sums all values over roughly the lowest negative val that can be stored. So effectively {=SUM(IFFEROR(rng),"")}.

I would have expected errors to float out from these functions (I might argue that’s actually more like expected behaviour). As we likely know, these functions don’t allow for arrays to be supplied as into the range arguments, so we don’t get to apply something like SUMIFS(IFERROR(values,""),IFERROR(names,""),"Bob") but owing an interesting way in which errors appear to compare to values, we can effectively set them outside criteria..

I will comment an image with some examples of this.