Difference between revisions of "Manuals/calci/SUBTOTAL"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
(No difference)
|
Revision as of 21:45, 24 October 2013
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 |