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
database/5a8fc1 =DSUM(A1:D5, "Price", F1:F2) 22 gsheets22 excel22 lattice22 ironcalc22 hyperformula#NAME? libreoffice22 formulas#NAME? pycel#NAME?
database/1f4ec2 =DSUM(A1:D5, 4, F1:F2) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#NAME? libreoffice12 formulas#NAME? pycel#NAME?
database/201c1c =DSUM(A1:D5, "Units", H1:H2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice8 formulas#NAME? pycel#NAME?
database/98c9d4 =DSUM(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice0 formulas#NAME? pycel#NAME?
database/b5aa8f =DCOUNT(A1:D5, "Price", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/aa13ea =DCOUNT(A1:D5, 3, H1:H2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/483c3c =DCOUNT(A1:D5, "Product", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice0 formulas#NAME? pycel#NAME?
database/eefd74 =DCOUNT(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice0 formulas#NAME? pycel#NAME?
database/3a0fb1 =DCOUNTA(A1:D5, "Product", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/6facf4 =DCOUNTA(A1:D5, 1, G1:G2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/448dc9 =DCOUNTA(A1:D5, "Product", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice0 formulas#NAME? pycel#NAME?
database/65c83b =DGET(A1:D5, "Price", F1:G2) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula#NAME? libreoffice10 formulas#NAME? pycel#NAME?
database/a01892 =DGET(A1:D5, 4, F1:G2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice4 formulas#NAME? pycel#NAME?
database/1bd2b2 =DGET(A1:D5, "Price", F1:F2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NAME? libreoffice#VALUE! formulas#NAME? pycel#NAME?
database/f49ea4 =DGET(A1:D5, "Price", F1:F2) #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#VALUE! hyperformula#NAME? libreoffice#VALUE! formulas#NAME? pycel#NAME?
database/e57087 =DMAX(A1:D5, "Price", F1:F2) 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#NAME? libreoffice12 formulas#NAME? pycel#NAME?
database/e80b3e =DMAX(A1:D5, 4, G1:G2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice8 formulas#NAME? pycel#NAME?
database/ec5618 =DMAX(A1:D5, "Units", H1:H2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice8 formulas#NAME? pycel#NAME?
database/640a0e =DMIN(A1:D5, "Price", F1:F2) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula#NAME? libreoffice10 formulas#NAME? pycel#NAME?
database/f7ae1e =DMIN(A1:D5, 3, G1:G2) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#NAME? libreoffice5 formulas#NAME? pycel#NAME?
database/76809b =DMIN(A1:D5, "Units", H1:H2) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#NAME? libreoffice3 formulas#NAME? pycel#NAME?
database/c014a6 =DPRODUCT(A1:D5, "Price", F1:F2) 120 gsheets120 excel120 lattice120 ironcalc120 hyperformula#NAME? libreoffice120 formulas#NAME? pycel#NAME?
database/899b99 =DPRODUCT(A1:D5, 4, G1:G2) 40 gsheets40 excel40 lattice40 ironcalc40 hyperformula#NAME? libreoffice40 formulas#NAME? pycel#NAME?
database/b2c657 =DPRODUCT(A1:D5, "Price", F1:F2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#NAME? libreoffice0 formulas#NAME? pycel#NAME?
database/54f0f6 =DAVERAGE(A1:D5, "Price", F1:F2) 11 gsheets11 excel11 lattice11 ironcalc11 hyperformula#NAME? libreoffice11 formulas#NAME? pycel#NAME?
database/d7c82a =DAVERAGE(A1:D5, 3, G1:G2) 7.5 gsheets7.5 excel7.5 lattice7.5 ironcalc7.5 hyperformula#NAME? libreoffice7.5 formulas#NAME? pycel#NAME?
database/3f3c2f =DAVERAGE(A1:D5, "Units", H1:H2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice4 formulas#NAME? pycel#NAME?
database/a92456 =DSTDEVP(A1:D5, "Units", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/dd05db =DSTDEVP(A1:D5, 3, F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice1 formulas#NAME? pycel#NAME?
database/b3cfa9 =DSTDEVP(A1:D5, 4, F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/79f01b =DVAR(A1:D5, "Price", F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/e75f6f =DVAR(A1:D5, 4, F1:F2) 8 gsheets8 excel8 lattice8 ironcalc8 hyperformula#NAME? libreoffice8 formulas#NAME? pycel#NAME?
database/78f111 =DVAR(A1:D5, 3, F1:F2) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#NAME? libreoffice2 formulas#NAME? pycel#NAME?
database/9176d0 =DVARP(A1:D5, "Price", F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice1 formulas#NAME? pycel#NAME?
database/e6cff8 =DVARP(A1:D5, 4, F1:F2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula#NAME? libreoffice4 formulas#NAME? pycel#NAME?
database/699c35 =DVARP(A1:D5, 3, F1:F2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#NAME? libreoffice1 formulas#NAME? pycel#NAME?