PhpSpreadsheet Calculation Function Examples

Database Function Examples

DAVERAGE
Returns the average of selected database entries.
DCOUNT
Counts the cells that contain numbers in a database.
DGET
Extracts a single value from a column of a list or database that matches conditions that you specify.
DMAX
Returns the maximum value from selected database entries.
DMIN
Returns the minimum value from selected database entries.
DPRODUCT
Multiplies the values in a column of a list or database that match conditions that you specify.
DSTDEV
Estimates the standard deviation based on a sample of selected database entries.
DSTDEVP
Calculates the standard deviation based on the entire population of selected database entries.
DVAR
Estimates variance based on a sample from selected database entries.
DVARP
Calculates variance based on the entire population of selected database entries,

DateTime Function Examples

DATE
Returns the serial number of a particular date.
DATEVALUE
Converts a date in the form of text to a serial number.
TIME
Returns the serial number of a particular time.
TIMEVALUE
Converts a time in the form of text to a serial number.