assay

DV-0011

formulas, hyperformula, pycel: function not implemented — DAVERAGE, DCOUNT, DCOUNTA (+8 more)

Cause
missing-function
Category
value
Diverging engines
formulashyperformulapycel
Behavior signature
{"error":"#NAME?"}
Test count
36
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (11)

DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEVP DSUM DVAR DVARP

Tests (36)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
DSUM/dsum-apples-total =DSUM(A1:D5, "Price", F1:F2) 22 gsheets22 excel22 lattice22 ironcalc22 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSUM/dsum-field-by-index =DSUM(A1:D5, 4, F1:F2) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSUM/dsum-comparator-criteria =DSUM(A1:D5, "Units", H1:H2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSUM/dsum-empty-result =DSUM(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNT/dcount-apples =DCOUNT(A1:D5, "Price", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNT/dcount-field-by-index =DCOUNT(A1:D5, 3, H1:H2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNT/dcount-ignores-text-in-numeric-field =DCOUNT(A1:D5, "Product", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNT/dcount-empty-result =DCOUNT(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNTA/dcounta-apples =DCOUNTA(A1:D5, "Product", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNTA/dcounta-field-by-index =DCOUNTA(A1:D5, 1, G1:G2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DCOUNTA/dcounta-empty-result =DCOUNTA(A1:D5, "Product", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DGET/dget-single-match =DGET(A1:D5, "Price", F1:G2) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DGET/dget-field-by-index =DGET(A1:D5, 4, F1:G2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DGET/dget-multiple-matches-error =DGET(A1:D5, "Price", F1:F2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DGET/dget-no-match-error =DGET(A1:D5, "Price", F1:F2) #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#VALUE! hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMAX/dmax-apples =DMAX(A1:D5, "Price", F1:F2) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMAX/dmax-field-by-index =DMAX(A1:D5, 4, G1:G2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMAX/dmax-comparator-criteria =DMAX(A1:D5, "Units", H1:H2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMIN/dmin-apples =DMIN(A1:D5, "Price", F1:F2) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMIN/dmin-field-by-index =DMIN(A1:D5, 3, G1:G2) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DMIN/dmin-all-rows =DMIN(A1:D5, "Units", H1:H2) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DPRODUCT/dproduct-apples-price =DPRODUCT(A1:D5, "Price", F1:F2) 120 gsheets120 excel120 lattice120 ironcalc120 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DPRODUCT/dproduct-field-by-index =DPRODUCT(A1:D5, 4, G1:G2) 40 gsheets40 excel40 lattice40 ironcalc40 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DPRODUCT/dproduct-empty-result =DPRODUCT(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DAVERAGE/daverage-apples =DAVERAGE(A1:D5, "Price", F1:F2) 11 gsheets11 excel11 lattice11 ironcalc11 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DAVERAGE/daverage-field-by-index =DAVERAGE(A1:D5, 3, G1:G2) 7.5 gsheets7.5 excel7.5 lattice7.5 ironcalc7.5 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DAVERAGE/daverage-comparator-criteria =DAVERAGE(A1:D5, "Units", H1:H2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSTDEVP/dstdevp-bananas-units =DSTDEVP(A1:D5, "Units", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSTDEVP/dstdevp-apples-price =DSTDEVP(A1:D5, 3, F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DSTDEVP/dstdevp-field-by-index =DSTDEVP(A1:D5, 4, F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVAR/dvar-apples-price =DVAR(A1:D5, "Price", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVAR/dvar-bananas-units =DVAR(A1:D5, 4, F1:F2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVAR/dvar-field-by-index =DVAR(A1:D5, 3, F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVARP/dvarp-apples-price =DVARP(A1:D5, "Price", F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVARP/dvarp-bananas-units =DVARP(A1:D5, 4, F1:F2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
DVARP/dvarp-field-by-index =DVARP(A1:D5, 3, F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?