# Manuals/calci/SUBTOTAL

**SUBTOTAL (Type,Arrays)**

where,

- specifies which function type to use within a list,
- is set of values or range of cells containing values.
- SUBTOTAL(), returns a subtotal in a list or database.

## Description

SUBTOTAL(Type, Arrays)

- SUBTOTAL() function is designed for columns of data or vertical range of cells.
- Argument specifies which function to use in calculating subtotal from the list of functions. can be any number between 1 to 11 (that includes hidden values) or 101 to 111 (that ignores hidden values).
- Below table describes the Function Type and the number associated with it.

Function Type | Function Number(includes hidden values) | Function Number(ignores 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 |

- is an array of values or reference to cells containing values, for which the subtotal is to be calculated.
- Text values or empty cells are ignored.
- For invalid argument values, Calci displays an error message.

## Examples

40 | |

50 | |

25.5 | |

80 | |

15.5 | |

-2 |

=SUBTOTAL(4,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using MAX function. Returns80as a result. =SUBTOTAL(5,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using MIN function. Returns-2as a result. =SUBTOTAL(9,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using SUM function. Returns209as a result. =SUBTOTAL(1,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using AVERAGE function. Returns34.833333333333336as a result.

## Related Videos

## See Also

## References