deepcalc
DocsSUBTOTAL

SUBTOTAL

View as markdown/docs/functions/subtotal.md Ask Claude about this pageOpens Claude with this page's address

Returns subtotal using specified function.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=SUBTOTAL(9, A1:A10)
A
1 10
2 20
3 30
4 40
5 50
Result 150

Syntax

SUBTOTAL(function_num, ref…)
function_num
number required
ref…
range required
BESSELIReturns modified Bessel function In(x). BESSELJReturns Bessel function Jn(x). BESSELKReturns modified Bessel function Kn(x). BESSELYReturns Bessel function Yn(x). BIN2DECConverts binary number to decimal. BIN2HEXConverts binary number to hexadecimal.