# SUBTOTAL

## Content

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. Setting the row height to zero also hides the values.

## Examples

`SUBTOTAL(8,A1:B7)`