xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Statistical/AVERAGEIF.php

<?php

return [
    [
        14000,
        [7000, 14000, 21000, 28000],
        '<23000',
    ],
    [
        150000,
        [100000, 200000, 300000, 400000],
        '<250000',
    ],
    [
        '#DIV/0!',
        [100000, 200000, 300000, 400000],
        '<95000',
    ],
    [
        24500,
        [100000, 200000, 300000, 400000],
        '>250000',
        [7000, 14000, 21000, 28000],
    ],
    [
        8.2,
        [2012, 2012, 2013, 2011, 2011, 2010],
        2012,
        [6, 10.4, 7, 12, 8, 15],
    ],
    [
        10,
        [2012, 2012, 2013, 2011, 2011, 2010],
        2011,
        [6, 10.4, 7, 12, 8, 15],
    ],
    [
        7.8,
        [2012, 2012, 2013, 2011, 2011, 2010],
        '>=2012',
        [6, 10.4, 7, 12, 8, 15],
    ],
    [
        2011.2,
        [2012, 2012, 2013, 2011, 2011, 2010],
        '<2013',
    ],
    [
        200,
        [7000, 14000, 21000, 28000],
        '<23000',
        [100, 200, 300, 800],
    ],
    [
        (2 + 4 + 8) / 3,
        [true, true, false, true, false],
        true,
        [2, 4, 6, 8, 10],
    ],
    [
        (6 + 10) / 2,
        [true, true, false, true, false],
        '<>true',
        [2, 4, 6, 8, 10],
    ],
    [
        (1 + 2 + 5 + 6) / 4,
        ['North', 'South', 'East', 'West', 'North', 'South', 'East', 'West'],
        '???th',
        [1, 2, 3, 4, 5, 6, 7, 8],
    ],
    [
        16733.5,
        ['East', 'West', 'North', 'South (New Office)', 'Midwest'],
        '=*West',
        [45678, 23789, -4789, 0, 9678],
    ],
    [
        18589,
        ['East', 'West', 'North', 'South (New Office)', 'Midwest'],
        '<>*(New Office)',
        [45678, 23789, -4789, 0, 9678],
    ],
];