Documentation

Conditional
in package

Table of Contents

Methods

AVERAGEIF()  : null|int|float|string
AVERAGEIF.
AVERAGEIFS()  : null|int|float|string
AVERAGEIFS.
COUNTIF()  : string|int
COUNTIF.
COUNTIFS()  : int|string
COUNTIFS.
MAXIFS()  : null|float|string
MAXIFS.
MINIFS()  : null|float|string
MINIFS.
SUMIF()  : null|float|string
SUMIF.
SUMIFS()  : null|float|string
SUMIFS.

Methods

AVERAGEIF()

AVERAGEIF.

public static AVERAGEIF(mixed $range, null|array<string|int, mixed>|string $condition[, mixed $averageRange = [] ]) : null|int|float|string

Returns the average value from a range of cells that contain numbers within the list of arguments

Excel Function: AVERAGEIF(range,condition[, average_range])

Parameters
$range : mixed

Data values, expect array

$condition : null|array<string|int, mixed>|string

the criteria that defines which cells will be checked

$averageRange : mixed = []

Data values

Return values
null|int|float|string

AVERAGEIFS()

AVERAGEIFS.

public static AVERAGEIFS(mixed ...$args) : null|int|float|string

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

Excel Function: AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|int|float|string

COUNTIF()

COUNTIF.

public static COUNTIF(mixed $range, null|array<string|int, mixed>|string $condition) : string|int

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

Excel Function: COUNTIF(range,condition)

Parameters
$range : mixed

Data values, expect array

$condition : null|array<string|int, mixed>|string

the criteria that defines which cells will be counted

Return values
string|int

COUNTIFS()

COUNTIFS.

public static COUNTIFS(mixed ...$args) : int|string

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

Excel Function: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
int|string

MAXIFS()

MAXIFS.

public static MAXIFS(mixed ...$args) : null|float|string

Returns the maximum value within a range of cells that contain numbers within the list of arguments

Excel Function: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string

MINIFS()

MINIFS.

public static MINIFS(mixed ...$args) : null|float|string

Returns the minimum value within a range of cells that contain numbers within the list of arguments

Excel Function: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string

SUMIF()

SUMIF.

public static SUMIF(mixed $range, mixed $condition[, mixed $sumRange = [] ]) : null|float|string

Totals the values of cells that contain numbers within the list of arguments

Excel Function: SUMIF(range, criteria, [sum_range])

Parameters
$range : mixed

Data values, expecting array

$condition : mixed
$sumRange : mixed = []

Data values, expecting array

Return values
null|float|string

SUMIFS()

SUMIFS.

public static SUMIFS(mixed ...$args) : null|float|string

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

Excel Function: SUMIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results