Manuals/calci/SUBTOTAL
Syntax
Remarks
Examples
''''''' ''''
Description
SUBTOTAL
SUBTOTAL(N1, N2, ...)
It is generally used in columns of data. The columns can have resultant values of other functions.
This function calculates subtotal in the list.
Lets see an example,
B
60
12
120
25
=SUBTOTAL(4,B2:B5) is 120
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 60 | 120 | ||
| Row2 | 12 | |||
| Row3 | 120 | |||
| Row4 | 25 | |||
| Row5 | ||||
| Row6 |
