statistical-descriptive

`averageifs-no-match`

Subject: AVERAGEIFS
Category: value
Formula: =AVERAGEIFS(A1:A3, B1:B3, "q")
Canonical: #DIV/0!

Owning divergences (1)

DV-0006 hyperformula: function not implemented — AND, AVERAGE, AVERAGEIFS (+19 more)
missing-function hyperformula

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	#DIV/0!
excel	match	#DIV/0!
lattice	match	#DIV/0!
ironcalc	match	#DIV/0!
hyperformula	diverge	#NAME?
libreoffice	diverge	—
formulas	match	#DIV/0!
pycel	match	#DIV/0!