Documentation

Counts extends AggregateBase
in package

Table of Contents

Methods

COUNT()  : int
COUNT.
COUNTA()  : int
COUNTA.
COUNTBLANK()  : int
COUNTBLANK.
isAcceptedCountable()  : bool
testAcceptedBoolean()  : mixed
MS Excel does not count Booleans if passed as cell values, but they are counted if passed as literals.

Methods

COUNT()

COUNT.

public static COUNT(mixed ...$args) : int

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

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

Parameters
$args : mixed

Data values

Return values
int

COUNTA()

COUNTA.

public static COUNTA(mixed ...$args) : int

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

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

Parameters
$args : mixed

Data values

Return values
int

COUNTBLANK()

COUNTBLANK.

public static COUNTBLANK(mixed $range) : int

Counts the number of empty cells within the list of arguments

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

Parameters
$range : mixed

Data values

Return values
int

isAcceptedCountable()

protected static isAcceptedCountable(mixed $arg, mixed $k[, bool $countNull = false ]) : bool
Parameters
$arg : mixed
$k : mixed
$countNull : bool = false
Return values
bool

testAcceptedBoolean()

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

protected static testAcceptedBoolean(mixed $arg, mixed $k) : mixed

OpenOffice Calc always counts Booleans. Gnumeric never counts Booleans.

Parameters
$arg : mixed
$k : mixed

        
On this page

Search results