Spread 8.0 Documentation
SUBTOTAL
Support Options
Formula Reference > Built-In Functions > SUBTOTAL

Glossary Item Box

SUBTOTAL


Name

Subtotal

Description

Calculates a subtotal of a list of numbers using a specified built-in function.

Syntax

SUBTOTAL(functioncode, value1,value2, . . . )

SUBTOTAL(functioncode,array)

Remarks

The functioncode argument is the number that represents the built-in function to use for the subtotal, as given in this table:

Built-In Function Function Code
AVERAGE 1
COUNT 2
COUNTA 3
MAX 4
MIN 5
PRODUCT 6
STDEV 7
STDEVP 8
SUM 9
VAR 10
VARP 11

Each additional argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments can be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

The SUBTOTAL function does not include other SUBTOTAL formula results that are in the same range.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

SUBTOTAL(8,A1:B7)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.