﻿ SUBTOTAL | Spread.NET 16 Formula Reference
Formula Functions / Functions R to S / SUBTOTAL
In This Topic
SUBTOTAL
In This Topic

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

#### Syntax

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

SUBTOTAL(functioncode,array)

#### Arguments

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 (Include Hidden Values) Function Code (Ignore Hidden Values)
AVERAGE 1 101
COUNT 2 102
COUNTA 3 103
MAX 4 104
MIN 5 105
PRODUCT 6 106
STDEV 7 107
STDEVP 8 108
SUM 9 109
VAR 10 110
VARP 11 111

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.

#### Remarks

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

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

SUBTOTAL(8,A1:B7)

#### Version Available

This function is available in product version 2.0 or later.