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.