08df77 |
AVERAGE |
=AVERAGE(1, 2, 3, 4) |
value |
|
49433a |
AVERAGE |
=AVERAGE(B1:B3) |
value |
|
1bea03 |
COUNT |
=COUNT(B1:B3) |
value |
1 |
7af6f0 |
COUNT |
=COUNT(1, 2, 3) |
value |
|
f04230 |
COUNTA |
=COUNTA(B1:B3) |
value |
|
d84a49 |
COUNTBLANK |
=COUNTBLANK(A1:A5) |
value |
|
28ddd6 |
COUNTIF |
=COUNTIF(A1:A4, ">2") |
value |
|
4b7dc0 |
MAX |
=MAX(1, 5, 3, 2, 4) |
value |
|
d6bdbe |
MAX |
=MAX(A1:A3) |
value |
|
493897 |
MIN |
=MIN(1, 5, 3, 2, 4) |
value |
|
9181cb |
MIN |
=MIN(A1:A3) |
value |
|
26d355 |
LARGE |
=LARGE({3,1,4,1,5,9}, 1) |
value |
|
e01cb8 |
LARGE |
=LARGE({3,1,4,1,5,9}, 3) |
value |
|
ac4ba7 |
SMALL |
=SMALL({3,1,4,1,5,9}, 1) |
value |
|
5b7abe |
SMALL |
=SMALL({3,1,4,1,5,9}, 2) |
value |
|
4f7c54 |
MEDIAN |
=MEDIAN(1, 2, 3, 4, 5) |
value |
1 |
3fca02 |
MEDIAN |
=MEDIAN(1, 2, 3, 4) |
value |
1 |
4bb69f |
SUMIF |
=SUMIF(A1:A3, ">1") |
value |
|
c5c05e |
SUMIFS |
=SUMIFS(A1:A4, B1:B4, "=A*") |
value |
|
76d4c7 |
MAXIFS |
=MAXIFS(A1:A4, B1:B4, "=A*") |
value |
1 |
c61d6a |
MINIFS |
=MINIFS(A1:A4, B1:B4, "=A*") |
value |
1 |