average-basic |
AVERAGE |
=AVERAGE(1, 2, 3, 4) |
value |
|
average-with-grid |
AVERAGE |
=AVERAGE(B1:B3) |
value |
|
count-numbers-only |
COUNT |
=COUNT(B1:B3) |
value |
1 |
count-inline-statistical |
COUNT |
=COUNT(1, 2, 3) |
value |
|
counta-non-empty |
COUNTA |
=COUNTA(B1:B3) |
value |
|
countblank |
COUNTBLANK |
=COUNTBLANK(A1:A5) |
value |
|
countif-greater-than |
COUNTIF |
=COUNTIF(A1:A4, ">2") |
value |
|
max-basic |
MAX |
=MAX(1, 5, 3, 2, 4) |
value |
|
max-with-grid |
MAX |
=MAX(A1:A3) |
value |
|
min-basic |
MIN |
=MIN(1, 5, 3, 2, 4) |
value |
|
min-with-grid |
MIN |
=MIN(A1:A3) |
value |
|
large-1st-statistical |
LARGE |
=LARGE({3,1,4,1,5,9}, 1) |
value |
|
large-3rd-statistical |
LARGE |
=LARGE({3,1,4,1,5,9}, 3) |
value |
|
small-1st-statistical |
SMALL |
=SMALL({3,1,4,1,5,9}, 1) |
value |
|
small-2nd |
SMALL |
=SMALL({3,1,4,1,5,9}, 2) |
value |
|
median-odd-count-statistical |
MEDIAN |
=MEDIAN(1, 2, 3, 4, 5) |
value |
1 |
median-even-count-statistical |
MEDIAN |
=MEDIAN(1, 2, 3, 4) |
value |
1 |
sumif-greater-than |
SUMIF |
=SUMIF(A1:A3, ">1") |
value |
|
sumifs-with-text-criteria |
SUMIFS |
=SUMIFS(A1:A4, B1:B4, "=A*") |
value |
|
maxifs-with-criteria |
MAXIFS |
=MAXIFS(A1:A4, B1:B4, "=A*") |
value |
1 |
minifs-with-criteria |
MINIFS |
=MINIFS(A1:A4, B1:B4, "=A*") |
value |
1 |