statistical-descriptive

`averagea-text-literal`

Subject: AVERAGEA
Category: value
Formula: =AVERAGEA(1, "hello", 2)
Canonical: 1

Owning divergences (2)

DV-0001 pycel: function not implemented — AVEDEV, AVERAGEA, COLUMNS (+75 more)
missing-function pycel
DV-0219 excel, formulas, gsheets, hyperformula, ironcalc: different error code — AVERAGEA
error-code excelformulasgsheetshyperformulaironcalc

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	diverge	[object Object]
excel	diverge	[object Object]
lattice	match	1
ironcalc	diverge	#VALUE!
hyperformula	diverge	#VALUE!
libreoffice	diverge	—
formulas	diverge	#VALUE!
pycel	diverge	#NAME?