SUBTOTAL

Name

SUBTOTAL —
SUMIF(function_nbr,ref1,ref2,...)

Description

SUBTOTAL function returns a subtotal of given list of arguments. @function_nbr is the number that specifies which function to use in calculating the subtotal. The following functions are available:

1 AVERAGE

2 COUNT

3 COUNTA

4 MAX

5 MIN

6 PRODUCT

7 STDEV

8 STDEVP

9 SUM

10 VAR

11 VARP

See also

COUNT , SUM