PHPOffice / PhpSpreadsheet

     *

     * @return float

     */

    public static function MAXIF($aArgs, $condition, $sumArgs = [])

    {

        $returnValue = null;

        $aArgs = Functions::flattenArray($aArgs);

        $sumArgs = Functions::flattenArray($sumArgs);

        if (empty($sumArgs)) {

            $sumArgs = $aArgs;

        }

        $condition = Functions::ifCondition($condition);

        // Loop through arguments

        foreach ($aArgs as $key => $arg) {

            if (!is_numeric($arg)) {

                $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));

            }

            $testCondition = '=' . $arg . $condition;

            if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {

                if ((is_null($returnValue)) || ($arg > $returnValue)) {

                    $returnValue = $arg;

                }

            }

        }

        return $returnValue;

    }

    /**

     * MEDIAN.

     *

     * @return float

     */

    public static function MINIF($aArgs, $condition, $sumArgs = [])

    {

        $returnValue = null;

        $aArgs = Functions::flattenArray($aArgs);

        $sumArgs = Functions::flattenArray($sumArgs);

        if (empty($sumArgs)) {

            $sumArgs = $aArgs;

        }

        $condition = Functions::ifCondition($condition);

        // Loop through arguments

        foreach ($aArgs as $key => $arg) {

            if (!is_numeric($arg)) {

                $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));

            }

            $testCondition = '=' . $arg . $condition;

            if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {

                if ((is_null($returnValue)) || ($arg < $returnValue)) {

                    $returnValue = $arg;

                }

            }

        }

        return $returnValue;

    }

    //

    //    Special variant of array_count_values that isn't limited to strings and integers,