Skip to content

Excel functions · 12 functions

Excel database functions

The D… functions treat a list with headers as a database and sum, count or average the records that match a separate criteria range. In new workbooks SUMIFS and FILTER are usually preferred.

All functions

  • DAVERAGEVSEÇORT

    Average of the field for matching records.

    =DAVERAGE(database, field, criteria)
  • DCOUNTVSEÇSAY

    Counts numbers in the field of matching records.

    =DCOUNT(database, [field], criteria)
  • DCOUNTAVSEÇSAYDOLU

    Counts non-blank cells in the field of matching records.

    =DCOUNTA(database, [field], criteria)
  • DGETVAL

    The field of the single matching record.

    =DGET(database, field, criteria)
  • DMAXVSEÇMAK

    Maximum of the field for matching records.

    =DMAX(database, field, criteria)
  • DMINVSEÇMİN

    Minimum of the field for matching records.

    =DMIN(database, field, criteria)
  • DPRODUCTVSEÇÇARP

    Product of the field for matching records.

    =DPRODUCT(database, field, criteria)
  • DSTDEVVSEÇSTDSAPMA

    Sample standard deviation of matching records.

    =DSTDEV(database, field, criteria)
  • DSTDEVPVSEÇSTDSAPMAS

    Population standard deviation of matching records.

    =DSTDEVP(database, field, criteria)
  • DSUMVSEÇTOPLA

    Adds the field of database records that match the criteria.

    =DSUM(database, field, criteria)
  • DVARVSEÇVAR

    Sample variance of matching records.

    =DVAR(database, field, criteria)
  • DVARPVSEÇVARS

    Population variance of matching records.

    =DVARP(database, field, criteria)

Excel functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free