assay
error-handling

aggregate-sum-ignoring-errors

Subject
AGGREGATE
Category
value
Formula
=AGGREGATE(9, 6, A1:A3)
Canonical
4

Owning divergences (2)

Per-engine results

matches canonical diverges no fixture

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