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)
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