Sum
Table of Contents
- product() : float|string
- SUMPRODUCT.
- sumErroringStrings() : float|string
- SUM, returning error for non-numeric strings. This is used by Excel SUM function.
- sumIgnoringStrings() : float|string
- SUM, ignoring non-numeric non-error strings. This is eventually used by SUMIF.
Methods
product()
SUMPRODUCT.
public
static product(mixed ...$args) : float|string
Excel Function: SUMPRODUCT(value1[,value2[, ...]])
Parameters
- $args : mixed
-
Data values
Return values
float|string —The result, or a string containing an error
sumErroringStrings()
SUM, returning error for non-numeric strings. This is used by Excel SUM function.
public
static sumErroringStrings(mixed ...$args) : float|string
SUM computes the sum of all the values and cells referenced in the argument list.
Excel Function: SUM(value1[,value2[, ...]])
Parameters
- $args : mixed
-
Data values
Return values
float|string —sumIgnoringStrings()
SUM, ignoring non-numeric non-error strings. This is eventually used by SUMIF.
public
static sumIgnoringStrings(mixed ...$args) : float|string
SUM computes the sum of all the values and cells referenced in the argument list.
Excel Function: SUM(value1[,value2[, ...]])
Parameters
- $args : mixed
-
Data values