Gitee
\
Adbar
AlibabaCloud
Tea
Exception
FileForm
FileForm
Tests
Alipay
EasySDK
Base
Image
Models
OAuth
Models
Qrcode
Models
Video
Models
Kernel
Exceptions
Util
Marketing
OpenLife
Models
Pass
Models
TemplateMessage
Models
Member
Identification
Models
Payment
App
Models
Common
Models
FaceToFace
Models
Huabei
Models
Page
Models
Wap
Models
Security
TextRisk
Models
Test
base
image
oauth
video
Base
marketing
openlife
pass
templatemessage
member
identification
multipleFactory
payment
common
facetoface
huabei
security
textrisk
util
generic
Util
AES
Generic
Models
app
controller
middleware
model
validate
BaconQrCode
Common
Encoder
Exception
Renderer
Color
Eye
Image
Module
EdgeIterator
Path
RendererStyle
BaconQrCodeTest
Common
Encoder
BarcodeBakery
Barcode
Common
Drawer
BigintTest
BugHonorFileTimeTest
Complex
Composer
Autoload
DASPRiD
Enum
Exception
EnumTest
Endroid
QrCode
Exception
Factory
Tests
Writer
GuzzleHttp
Cookie
Exception
Handler
Promise
Psr7
JmesPath
Khanamiryan
QrCodeTests
League
Flysystem
Adapter
Polyfill
Cached
Storage
Plugin
Util
MimeTypeDetection
Matrix
Decomposition
Operators
MyCLabs
Enum
PHPUnit
org
PhpOffice
PhpSpreadsheet
Calculation
Database
Engine
Engineering
Internal
Logical
MathTrig
Statistical
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
Gnumeric
Ods
Security
Xls
Color
Style
Xlsx
Xml
RichText
Shared
Escher
DgContainer
SpgrContainer
DggContainer
BstoreContainer
BSE
JAMA
OLE
PPS
Trend
Style
ConditionalFormatting
Worksheet
AutoFilter
Column
Drawing
Writer
Ods
Cell
Pdf
Xls
Xlsx
Pimple
Exception
Psr11
Tests
Fixtures
Psr11
Psr
Cache
Container
Http
Client
Message
Log
Test
SimpleCache
Songshenzong
Support
Test
Core
Traits
spec
League
Flysystem
Cached
Stringy
Symfony
Component
OptionsResolver
Debug
Exception
PropertyAccess
Exception
PropertyInfo
DependencyInjection
Extractor
Util
String
Exception
Inflector
Slugger
VarDumper
Caster
Cloner
Command
Descriptor
Dumper
ContextProvider
Exception
Server
Test
Polyfill
Ctype
Intl
Grapheme
Normalizer
Mbstring
Php72
Php73
Php80
think
cache
driver
console
command
make
optimize
input
output
descriptor
driver
formatter
question
contract
db
builder
concern
connector
exception
event
exception
facade
file
filesystem
driver
helper
initializer
log
driver
middleware
model
concern
relation
paginator
driver
response
route
dispatch
service
session
driver
template
driver
exception
taglib
tests
trace
validate
view
driver
ZipStream
Exception
Option
ZipStreamTest
Zxing
Common
Detector
Reedsolomon
Qrcode
Decoder
Detector

\PhpOffice\PhpSpreadsheet\CalculationDatabase

Summary

Methods
Properties
Constants
DAVERAGE()
DCOUNT()
DCOUNTA()
DGET()
DMAX()
DMIN()
DPRODUCT()
DSTDEV()
DSTDEVP()
DSUM()
DVAR()
DVARP()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Methods

DAVERAGE()

DAVERAGE(array  $database, int|string  $field, array  $criteria) : null|float|string

DAVERAGE.

Averages the values in a column of a list or database that match conditions you specify.

Excel Function: DAVERAGE(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

null|float|string —

DCOUNT()

DCOUNT(array  $database, null|int|string  $field, array  $criteria) : int

DCOUNT.

Counts the cells that contain numbers in a column of a list or database that match conditions that you specify.

Excel Function: DCOUNT(database,[field],criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
null|int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

int —

DCOUNTA()

DCOUNTA(array  $database, null|int|string  $field, array  $criteria) : int

DCOUNTA.

Counts the nonblank cells in a column of a list or database that match conditions that you specify.

Excel Function: DCOUNTA(database,[field],criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
null|int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

int —

DGET()

DGET(array  $database, int|string  $field, array  $criteria) : mixed

DGET.

Extracts a single value from a column of a list or database that matches conditions that you specify.

Excel Function: DGET(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

mixed —

DMAX()

DMAX(array  $database, int|string  $field, array  $criteria) : float

DMAX.

Returns the largest number in a column of a list or database that matches conditions you that specify.

Excel Function: DMAX(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float —

DMIN()

DMIN(array  $database, int|string  $field, array  $criteria) : float

DMIN.

Returns the smallest number in a column of a list or database that matches conditions you that specify.

Excel Function: DMIN(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float —

DPRODUCT()

DPRODUCT(array  $database, int|string  $field, array  $criteria) : float

DPRODUCT.

Multiplies the values in a column of a list or database that match conditions that you specify.

Excel Function: DPRODUCT(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float —

DSTDEV()

DSTDEV(array  $database, int|string  $field, array  $criteria) : float|string

DSTDEV.

Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSTDEV(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float|string —

DSTDEVP()

DSTDEVP(array  $database, int|string  $field, array  $criteria) : float|string

DSTDEVP.

Calculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSTDEVP(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float|string —

DSUM()

DSUM(array  $database, int|string  $field, array  $criteria) : float

DSUM.

Adds the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSUM(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float —

DVAR()

DVAR(array  $database, int|string  $field, array  $criteria) : float|string

DVAR.

Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DVAR(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float|string —

(string if result is an error)

DVARP()

DVARP(array  $database, int|string  $field, array  $criteria) : float|string

DVARP.

Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DVARP(database,field,criteria)

Parameters

array $database

The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int|string $field

Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
array $criteria

The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns

float|string —

(string if result is an error)