assay
statistical

sumifs-with-text-criteria

Subject
SUMIFS
Category
value
Formula
=SUMIFS(A1:A4, B1:B4, "=A*")
Canonical
20

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match [object Object]
excel match [object Object]
lattice match 20
ironcalc match 20
hyperformula match 20
libreoffice diverge
formulas match 20
pycel match 20