\PhpOffice\PhpSpreadsheet\Calculation\StatisticalCounts

Summary

Methods
Properties
Constants
COUNT()
COUNTA()
COUNTBLANK()
No public properties found
No constants found
testAcceptedBoolean()
isAcceptedCountable()
No protected properties found
N/A
No private methods found
No private properties found
N/A

Methods

COUNT()

COUNT(mixed  ...$args) : int

COUNT.

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNT(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

int —

COUNTA()

COUNTA(mixed  ...$args) : int

COUNTA.

Counts the number of cells that are not empty within the list of arguments

Excel Function: COUNTA(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

int —

COUNTBLANK()

COUNTBLANK(mixed  ...$args) : int

COUNTBLANK.

Counts the number of empty cells within the list of arguments

Excel Function: COUNTBLANK(value1[,value2[, ...]])

Parameters

mixed $args variadic

Data values

Returns

int —

testAcceptedBoolean()

testAcceptedBoolean(mixed  $arg, mixed  $k) : int|mixed

MS Excel does not count Booleans if passed as cell values, but they are counted if passed as literals.

OpenOffice Calc always counts Booleans. Gnumeric never counts Booleans.

Parameters

mixed $arg
mixed $k

Returns

int|mixed —

isAcceptedCountable()

isAcceptedCountable(mixed  $arg, mixed  $k) : bool

Parameters

mixed $arg
mixed $k

Returns

bool —