statistical-descriptive

`averageif-exact-value`

Subject: AVERAGEIF
Category: value
Formula: =AVERAGEIF(A1:A4, 2)
Canonical: 2

Per-engine results

matches canonical diverges no fixture

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