Formualizer Docs

SUBTOTAL

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=SUBTOTAL(function_num, ref1, [ref2], ...)

Arguments

ArgumentTypeRequiredDefault
function_numnumber (range)Required—
ref1number (range)Required—
ref2number (range)Optional—

Accepts a variable number of arguments. Minimum: 2.

Examples

Select the sum operation over three source cells.

Formula =SUBTOTAL(9,A1:A3)

Input cells
A
15
210
320

Expected result 35

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Use operation one to calculate their average instead.

Formula =SUBTOTAL(1,A1:A3)

Input cells
A
15
210
320

Expected result 11.6666666666667

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Include a referenced nested SUBTOTAL to check how it contributes to the outer sum.

Formula =SUBTOTAL(9,A1:A3,B1)

Input cells
AB
15=SUBTOTAL(9,A1:A2)
210
320

Expected result 35

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

An unsupported operation number cannot select a subtotal calculation.

Formula =SUBTOTAL(99,A1:A3)

Input cells
A
15
210
320

Expected result #VALUE!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page