1 | value | ||
|---|---|---|---|
2 | 2 | ||
3 | -1 | ||
4 | 11 | ||
5 | |||
6 | TRUE | ||
7 | FALSE | ||
8 | |||
9 | |||
10 | Result | Formula | |
11 | 4 | =AVERAGE(A2:A4) | |
12 | 4 | =AVERAGE(A2:A5) | |
13 | 4 | =AVERAGE(A2:A5,A6,A7) | |
14 | 0.5 | =AVERAGE(TRUE, FALSE) | |
15 |
1 | value | ||
|---|---|---|---|
2 | 2 | ||
3 | -1 | ||
4 | 11 | ||
5 | |||
6 | TRUE | ||
7 | FALSE | ||
8 | |||
9 | |||
10 | Result | Formula | |
11 | 4 | =AVERAGEA(A2:A4) | |
12 | 3 | =AVERAGEA(A2:A5) | |
13 | 2.166666667 | =AVERAGEA(A2:A5,A6,A7) | |
14 | 0.5 | =AVERAGEA(TRUE, FALSE) | |
15 |