Microsoft Office Tutorials and References
In Depth Information
Summarizing worksheets by using hidden and filtered rows
The following table summarizes the summary operations available for use in the
AGGREGATE function.
Number
Function
Description
1
AVERAGE
Returns the average of the values in the range.
2
COUNT
Counts the cells in the range that contain a
number.
3
COUNTA
Counts the nonblank cells in the range.
4
MAX
Returns the largest (maximum) value in the range.
5
MIN
Returns the smallest (minimum) value in the
range.
6
PRODUCT
Returns the result of multiplying all numbers in
the range.
7
STDEV.S
Calculates the standard deviation of the values in
the range by examining a sample of the values.
8
STDEV.P
Calculates the standard deviation of the values in
the range by using all the values.
9
SUM
Returns the result of adding all numbers in the
range together.
10
VAR.S
Calculates the variance of the values in the range
by examining a sample of the values.
11
VAR.P
Calculates the variance of the values in the range
by using all of the values.
12
MEDIAN
Returns the value in the middle of a group of
values.
13
MODE.SNGL
Returns the most frequently occurring number
from a group of numbers.
14
LARGE
Returns the k-th largest value in a data set; k is
specified by using the last function argument. If k
is left blank, Excel returns the largest value.
15
SMALL
Returns the k-th smallest value in a data set; k is
specified by using the last function argument. If k
is left blank, Excel returns the smallest value.
16
PERCENTILE.INC
Returns the k-th percentile of values in a range,
where k is a value from 0 to 1, inclusive.
Search JabSto ::




Custom Search