Database/DAverage.php

PhpSpreadsheet · src/PhpSpreadsheet/Calculation/Database/DAverage.php · php · MIT
database

Calculates the average of a database column that matches given criteria.

// Source: https://github.com/PHPOffice/PhpSpreadsheet | License: MIT | Copyright 2019-2026 PhpSpreadsheet Authors
// Provided via justclaw.it.com; keep this notice with the code.
<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\Database;

use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Averages;

class DAverage extends DatabaseAbstract
{
    /**
     * DAVERAGE.
     *
     * Averages the values in a column of a list or database that match conditions you specify.
     *
     * Excel Function:
     *        DAVERAGE(database,field,criteria)
     *
     * @param mixed[] $database The range of cells that makes up the list or database.
     *                          A database is a list of related data in which rows o

... (truncated -- full source via MCP)

See the full source, get the GitHub permalink, and search for more like it.

Get a free API key