assay
broadcasting

double-unary-coerces-boolean-row-to-numeric

Subject
SUMPRODUCT
Category
value
Formula
=SUMPRODUCT(--({1,2,3}>1))
Canonical
2

Owning divergences (3)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match 2
excel match 2
lattice match 2
ironcalc diverge #NAME?
hyperformula match 2
libreoffice diverge
formulas diverge 0
pycel diverge #NAME?