-
Notifications
You must be signed in to change notification settings - Fork 3.3k
/
AVERAGEIFS.php
45 lines (44 loc) · 1.11 KB
/
AVERAGEIFS.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?php
return [
[
0,
],
[
80.5,
[75, 94, 86, 'incomplete'],
[75, 94, 86, 'incomplete'],
'>70',
[75, 94, 86, 'incomplete'],
'<90',
],
[
'#DIV/0!',
[85, 80, 93, 75],
[85, 80, 93, 75],
'>95',
],
[
87.5,
[87, 88, 'incomplete', 75],
[87, 88, 'incomplete', 75],
'<>incomplete',
[87, 88, 'incomplete', 75],
'>80',
],
[
174000,
[223000, 125000, 456000, 322000, 340000, 198000, 310000, 250000, 460000, 261000, 389000, 305000],
[1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4],
1,
['North', 'North', 'South', 'North', 'North', 'South', 'North', 'North', 'South', 'North', 'North', 'South'],
'North',
],
[
285500,
[223000, 125000, 456000, 322000, 340000, 198000, 310000, 250000, 460000, 261000, 389000, 305000],
[1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4],
'>2',
['Jeff', 'Chris', 'Carol', 'Jeff', 'Chris', 'Carol', 'Jeff', 'Chris', 'Carol', 'Jeff', 'Chris', 'Carol'],
'Jeff',
],
];